开发者

SQL Server view definition

开发者 https://www.devze.com 2023-01-31 03:41 出处:网络
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):

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

0

精彩评论

暂无评论...
验证码 换一张
取 消