Friday, March 30, 2012

get an ALTER statement for an existing view

In MSSQL Server Management Studio one may right-click on a Stored Procedure or Function and select "Modify" to get an ALTER SQL statement for adjusting the item. You may also get an ALTER statement for a view by right-clicking on the view and then selecting: Script View as > ALTER To > New Query Editor Window

No comments:

Post a Comment