Menu
Is it possible to change the default templates in SQL Server Management Studio? For example, when I right-click on a table and I choose "Script Table as" from the context menu, I can choose select, insert, update, etc. I would like to change the format of some of these sql scripts like you can with the templates in the template explorer.
925
Templates are boilerplate files containing SQL scripts that help you create objects in a database. The first time the template explorer is opened, a copy of the templates are placed in the user's folder in C:\Users, under AppData\Roaming\Microsoft\SQL Server Management Studio\130\Templates.
Right-click SQL Server Templates, and then select New > Folder. Right-click the template you created, and then select Edit.
'Tis possible only in Tools -> Options -> SQL Server Object Explorer -> Scripting
151
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
