Template Explorer
E277016
Template Explorer is a feature in SQL Server Management Studio that provides a categorized library of pre-built T-SQL scripts to help users quickly create and modify database objects and queries.
All labels observed (1)
| Label | Occurrences |
|---|---|
| Template Explorer canonical | 1 |
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server Management Studio feature
ⓘ
software development tool component ⓘ |
| accessibleVia |
View menu in SQL Server Management Studio
ⓘ
keyboard shortcut Ctrl+Alt+T in SSMS ⓘ |
| benefit |
improves consistency of database scripts
ⓘ
reduces manual coding errors in T-SQL scripts ⓘ saves time when creating common database objects ⓘ |
| containsCategory |
Database templates
ⓘ
Function templates ⓘ Index templates ⓘ Service Broker templates ⓘ Stored procedure templates ⓘ Table templates ⓘ Trigger templates ⓘ View templates ⓘ XML templates ⓘ |
| developedBy | Microsoft ⓘ |
| hasFeature |
ability to open templates in a query editor window
ⓘ
categorized template folders ⓘ integration with SSMS Object Explorer ⓘ placeholders for parameter values ⓘ pre-built script templates ⓘ support for user-defined templates ⓘ |
| hasPurpose |
help users quickly create database objects
ⓘ
help users quickly create queries ⓘ help users quickly modify database objects ⓘ help users quickly modify queries ⓘ provide a categorized library of pre-built T-SQL scripts ⓘ |
| introducedBy | SQL Server Management Studio 2005 era ⓘ |
| partOf |
SQL Server Management Studio
ⓘ
surface form:
SQL Server Management Studio user interface
|
| providedBy |
SQL Server Management Studio
ⓘ
SQL Server Management Studio ⓘ
surface form:
SSMS
|
| requires | SQL Server Management Studio installation ⓘ |
| runsOn |
Windows
ⓘ
surface form:
Microsoft Windows
|
| supportsLanguage |
T-SQL
ⓘ
T-SQL ⓘ
surface form:
Transact-SQL
|
| supportsVersion |
SQL Server
ⓘ
surface form:
SQL Server 2005 and later
SQL Server ⓘ
surface form:
SQL Server 2008 and later
SQL Server ⓘ
surface form:
SQL Server 2012 and later
SQL Server ⓘ
surface form:
SQL Server 2014 and later
SQL Server ⓘ
surface form:
SQL Server 2016 and later
SQL Server ⓘ
surface form:
SQL Server 2017 and later
SQL Server 2019 and later ⓘ SQL Server ⓘ
surface form:
SQL Server 2022 and later
|
| typicalUser |
data engineer
ⓘ
database administrator ⓘ database developer ⓘ |
| usedFor |
generating boilerplate T-SQL code
ⓘ
speeding up T-SQL script creation ⓘ standardizing common database tasks ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.