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?
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.
You can answer your own as well. But, in absence of that:
Tools -> Options -> SQL Server Object Explorer -> Scripting?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With