Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The definition of the target view does not change based on the changes made to the target table and therefore the view definition will become invalid. So, in the following example, after the script is executed, c3 and c4 columns are dropped from the target table, but the view is not refreshed.

Use a Single Transaction 

...