- Click on the "Views" folder to select it.
- Select "Object Explorer Details" from the View menu.
- A new pane should appear listing all of the views. Select them all.
- Right-click in the swath of selected views and select:
Script View as > CREATE To > New Query Editor Window - 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