How to open SQL Server Management Studio Template Explorer

To open SQL Server Management Studio (SSMS) Template Explorer and to view the templates, go to the View menu -> Template Explorer:

view_menu_template_explorer

...or press Ctrl+Alt+T keyboard keys to open Template Explorer.

The Template Explorer (Template Browser) will open inside SQL Server Management Studio:

template_browser_ssms_pane

You can expand each category and see the list of scripts inside:

expand_template_category

To open a template script, double click on it or drag it to Query Editor Window.