sync between a view and other concrete table.

• vchandm23

  Old Hand

  Points: 314

  More actions

  July 23, 2012 at 11:20 pm

  #264467

  Hi all,

  Here's the scenario. We tried to create a full text indexing on a view, unfortunately the view was created based on Left outer join. Hence we were pushed to do the following.

  We planned to create a table based on the data that is rendered in this view(this view is formed by combining 14 tables.) . Finally we were able to create a full text indexing on this new table. For simplicity let us called this new table as tableA.

  Now the problem is how can we update (if any data is changed on one of the concrete tables of the view) or insert (when new data is inserted in one of the underlying tables of the view) the respective data into this new table - tableA which was created based on this view.

  In other words, there should be a sync between the view and tableA. Is it possible to achieve this ???

  PS : view is formed based on different tables (not based on tableA)?

  Cheers,

  Chandra.

• DBA328

  Hall of Fame

  Points: 3952

  More actions

  July 24, 2012 at 3:20 am

  #1516675

  try sp_refreshview after you update table schema. In addtion, you could use SCHEMABINDING when you create the view. Binds the view to the schema of the underlying table or tables. When SCHEMABINDING is specified, the base table or tables cannot be modified in a way that would affect the view definition.