Breaking News
Loading...
08/08/2013

Generate script for many objecst in SQL Server Data Management Studio

Today I have learned a useful tips that help generate scripts for many database objects in SQL Server Management Studio. This is really useful in real work, where we have many similar databases and want to create many new objects.

Simply, in SQL Server Management Studio, select database, then select folder 'tables'

Then select Menu View -> Object Explorer Details

Final, select objects that you want to generate scripts. Done


Here is some screenshots to demonstrate.



For full information, please refer here: http://dattatreysindol.com/2012/06/14/tips-n-tricks-ssms-generate-script-for-multiple-select-objects-in-one-go/

0 comments:

Post a Comment

 
Toggle Footer