Auto generate change scripts in SQL Server Management Studio

SQL Server Management Studio has a feature that lets you to automatically generate Create or Alter scripts when using the table designer .

By deafult , this option is disabled . You can enable it by following the below steps

1. Start SQL Server Management Studio

2. Click Tools -> Options

Auto generate change scripts in SQL Server Management Studio - 1

Auto generate change scripts in SQL Server Management Studio - 1

3. Click Designers in the TreeList in the Options Dialog and select the option “Auto Generate Change Scripts” and click OK

Auto generate change scripts in SQL Server Management Studio - 2

Auto generate change scripts in SQL Server Management Studio - 2

4. Now , for test , try adding a column to an existing table and Save it . You will be prompted to save the change script .

Auto generate change scripts in SQL Server Management Studio - 3

Auto generate change scripts in SQL Server Management Studio - 3

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

Column Alias and Square brackets in SQL Query.
When we want to specify a alias for a column in SQL Query , we tend to use the double quotes or sing...
How to get the MAX row with group by in LINQ query using C# ?
Below is a sample code snippet demonstrating how to retreive the max row with the group by in LINQ Q...
Webinar - The Shortcomings of SQL for SharePoint Sync
Redmond Magazine is hosting a webinar on the topic "The Shortcomings of SQL for SharePoint Sync" on ...