January 31, 2013 at 4:43 pm
Update fails from union all view with below error message?
UNION ALL view is not updatable because a primary key was not found on table.
However, i cannot create primary key since union all view has multiple tables.
Thanks
January 31, 2013 at 10:36 pm
DO the the underlying tables in the view have primary keys defined?
February 1, 2013 at 7:18 am
There are a lot of rules around creating an updatable partitioned view.
Modifying Data in Partitioned Views
You can always fall back on implementing an INSTEAD OF TRIGGER.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply