- C# Scripts
- DWH INTERVIEW QUESTIONS
- MS Dynamics AX 2012 R2 Video Tutorial
- Project / Work Support
- SQL SERVER DBA INTERVIEW QUESTIONS
- SQL SERVER DBA Video Tutorial
- SQL Server / TSQL Tutorial
- SQL Server 2016
- SQL Server Scripts
- SSIS INTERVIEW QUESTIONS
- SSIS Video Tutorial
- SSRS INTERVIEW QUESTIONS
- SSRS Video Tutorial
- TSQL INTERVIEW QUESTIONS
- Team Foundation Server 2013 Video Tutorial
- Team Foundation Server 2015 Video Tutorial
- Windows 10
- Windows Server 2012 R2 Installation Videos
How to use Templates in SQL Server Management Studio (SSMS) - SQL Server / TSQL Tutorial Part 16
I am new developer or been working from long time but my memory is not that great;) every time I need to create an object, I forget the script and I have to go to Google or Microsoft website to get the template for create, alter object. Does SSMS has something like that so I can use that?
SQL Server Management Studio does have built-in templates and you can use them whenever you need them.
Here are the steps how to use Built-in Templates in SSMS.
Go to View Drop down and then choose Template Explorer
How to use Templates in SSMS - SQL Server Tutorial
Template Explorer will open and you will see a lot of templates as you can see some of them in below snapshot.
How to use built-in Templates in SSMS - SQL Server Tutorial Step by Step
Double click on template you would like to use. I clicked on Create Table and below window opened.
How to use Templates in SQL Server Management Studio- SQL Server Training
Now we can replace the existing values in template and change as we like. To provide the values for Template Parameters, Go to Query and then hit Specify Values for Template Parameter as shown below.
How to use Template in SSMS to create Table - SQL Server Tutorial for Beginners
Final step is to provide the values. Once you click Specify Values for Template Parameter, Below windows will open. Go ahead and make changes as per your requirement.
How to use built-in Templates in SSMS - SQL Server/TSQL Tutorial
How to Use Templates in SQL Server Management Studio - SQL Server Tutorial