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