Monday, June 18, 2012

MSSQL Management Studio Express will allow you to create a script for editing every view in a database.

  1. Click on the "Views" folder to select it.
  2. Select "Object Explorer Details" from the View menu.
  3. A new pane should appear listing all of the views. Select them all.
  4. Right-click in the swath of selected views and select:
       Script View as > CREATE To > New Query Editor Window
  5. You will be handed one big SQL script for creating all of the views which may be doctored up as needed.

No comments:

Post a Comment