Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Change default template in SQL Server Management Studio

Tags:

sql-server

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.

like image 925
Daniel Avatar asked Nov 05 '09 16:11

Daniel


People also ask

Where are SSMS templates stored?

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.

How do I edit a SQL template?

Right-click SQL Server Templates, and then select New > Folder. Right-click the template you created, and then select Edit.


1 Answers

'Tis possible only in Tools -> Options -> SQL Server Object Explorer -> Scripting

like image 151
silent Avatar answered Sep 23 '22 00:09

silent