SQL Server provides a variety of templates. 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.
You can browse the available templates in Template Explorer, then open a template to incorporate the code into a code editor window. You can also create custom templates.
Templates are available for solutions, projects, and various types of code editors. Templates are available to create objects like databases, tables, views, indexes, stored procedures, triggers, statistics, and functions. In addition, there are templates that help you to manage your server by creating extended properties, linked servers, logins, roles, users, and templates for Analysis Services.
The template scripts provided with SQL Server Management Studio contain parameters to help you customize the code. When you open a template, Use the Replace Template Parameters dialog box to insert values into the script.
Create custom templates for tasks you perform frequently. Organize your custom scripts into the existing folders or create a new folder structure.
The Database Engine Query editor also supports code snippets, which can be inserted at specific locations in a script by right-clicking at that location.