Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a way to set defaults for generate scripts in SQL Server 2008?

Most of the time when I generate script in SSMS, I have to changed the exact same number of settings in the Generate and Publish Scripts wizard. Is there a way to set the defaults in this wizard (particularly in the Advanced Scripting Options dialog?

If not, does anyone have any interesting ways of facilitating this need?

like image 467
Ben Jones Avatar asked Oct 04 '12 20:10

Ben Jones


People also ask

How do you generate create table script for all tables in SQL Server database?

Right click on the DB_NAME -> Select Task -> Select Generate Script. Follow along the presented wizard and select all tables in that database to generate the scripts.


1 Answers

You can answer your own as well. But, in absence of that:

Tools -> Options -> SQL Server Object Explorer -> Scripting? 
like image 50
davids Avatar answered Oct 21 '22 01:10

davids