How开发者_如何学运维 can I see the SQL script that was used to create view? I'm using MS SQL Server Management Studio Express 2008.
In object explorer (left hand pane):
- Right click the view
- Script View As ->
- CREATE TO ->
- New Query Editor Window
That will open a new query window with the create script for the view.
Right click on the View -> Modify
EDIT: Much better
Right click on the View -> Script View As -> Create TO
There you can export the create script to a destination of your choice
精彩评论