View issue

• Admingod

  SSCertifiable

  Points: 5997

  More actions

  January 31, 2013 at 4:43 pm

  #288404

  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

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  January 31, 2013 at 10:36 pm

  #1583264

  DO the the underlying tables in the view have primary keys defined?

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  February 1, 2013 at 7:18 am

  #1583440

  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