All Forums Database
spkother 18 posts Joined 07/13
17 Oct 2014
DML through multi table view

    I was trying to insert record into one of the base table through multi table view,it is giving error saying "View may not be used for insert/update/delete".but same insert working fine on single table view.Why?can anyone give explanation for this.

dnoeth 4628 posts Joined 11/04
18 Oct 2014

Hi Sravanthi,
Teradata (like most DBMSes) doesn't allow updates on multi-table views.
Only single-table SELECTs without JOIN, ORDER BY, aggregations or calculations can be updated.


spkother 18 posts Joined 07/13
18 Oct 2014

Thank you Dieter

You must sign in to leave a comment.