|
Features
|
Enterprise
|
Professional
|
Standard
|
|
Compatibility
|
|
|
|
|
SQL Server 2022
|
✔
|
✔
|
✔
|
|
SQL Server 2005
- 2019
|
✔
|
✔
|
✔
|
|
SQL Server 2000
|
✔ⓘ
|
✔ⓘ
|
✔ⓘ
|
|
SQL Server
installed on Linux
|
✔
|
✔
|
✔
|
|
Azure SQL
Database (SQL DB)
|
✔
|
✔
|
✔
|
|
Azure Synapse
Analytics (formerly
Azure SQL Data
Warehouse (SQL
DW)) Serverless
but not Dedicated
|
✔
|
✔
|
✔
|
|
Azure SQL
Managed Instance
(SQL MI)
|
✔
|
✔
|
✔
|
|
Microsoft Entra
multi-factor
authentication
(MFA) (formerly Azure
Active
Directory (Azure AD))
|
✔
|
✔
|
✔
|
|
Microsoft
Visual Studio 2015 - 2022
|
✔
|
✔
|
✔
|
|
SQL Server
Management Studio 2016,
17, 18, 19, and
20
|
✔
|
✔
|
✔
|
|
ⓘ : Limited functionality
|
|
|
Enterprise
|
Professional
|
Standard
|
|
Intelligent SQL
Completion
|
|
|
|
|
Smart
suggestions
|
✔
|
✔
|
✔
|
|
Wise filtering
in the suggestion list
|
✔
|
✔
|
✔
|
|
Database
context detection
|
✔
|
✔
|
✔
|
|
Context-sensitive
object suggestions
for SELECT,
DML, DROP, EXEC, SET,
and USE
statements
|
✔
|
✔
|
✔
|
|
Parameter
information for functions
|
✔
|
✔
|
✔
|
|
Rows Count
information
|
✔
|
✔
|
✔
|
|
ON condition
suggestion for JOIN
|
✔
|
✔
|
✔
|
|
Reverse ON
condition suggestion for
JOIN
|
✔
|
✔
|
✔
|
|
Pair
highlighting BEGIN END, CASE
END
|
✔
|
✔
|
✔
|
|
Semi-transparent
view of the
suggestion box
|
✔
|
✔
|
✔
|
|
Prompting
common table expressions
(CTE)
|
✔
|
✔
|
✔
|
|
Context-sensitive
suggestion of
keywords
|
✔
|
✔
|
✔
|
|
Quick object
information
|
✔
|
✔
|
✔
|
|
Name
suggestions for objects on
linked servers
|
✔
|
✔
|
✔
|
|
Column picker
for quick list building
|
✔
|
✔
|
✔
|
|
INSERT, EXEC,
ALTER and UPDATE
statements
expansion
|
✔
|
✔
|
✔
|
|
JOIN clause
auto generation
|
✔
|
✔
|
✔
|
|
Disable/Enable Code
Completion
|
✔
|
✔
|
✔
|
|
Wildcard
expansion
|
✔
|
✔
|
✔
|
|
INSERT, EXEC,
and ALTER statements
expansion
|
✔
|
✔
|
✔
|
|
UPDATE
statements expansion
|
✔
|
✔
|
✔
|
|
Auto-generation
of table aliases
|
✔
|
✔
|
✔
|
|
Context-sensitive
object suggestions
for T-SQL code,
DDL, and security
statements
|
✔
|
✔
|
✔
|
|
Context-sensitive
object suggestions
for common
table expressions (CTE)
|
✔
|
✔
|
✔
|
|
Context-sensitive
object suggestions
in SQLCMD mode
|
✔
|
✔
|
✔
|
|
SQL snippets
|
✔
|
✔
|
✔
|
|
Recently closed
documents
|
✔
|
✔
|
✔
|
|
Exclude
databases from suggestion
|
✔
|
✔
|
✔
|
|
Highlight
occurrences of an identifier
|
✔
|
✔
|
✔
|
|
Code completion
in SQLCMD mode
|
✔
|
✔
|
✔
|
|
Identifier
occurrences highlighting
|
✔
|
✔
|
✔
|
|
Sorting suggested
keywords by
relevance
|
✔
|
✔
|
✔
|
|
Custom alias
mapping
|
✔
|
✔
|
✔
|
|
Phrase
completion
|
✔
|
✔
|
✔
|
|
Pair
highlighting (BEGIN END; CASE
END)
|
✔
|
✔
|
✔
|
|
Highlight of
matching COLUMNS and
VALUES in the
INSERT statement
|
✔
|
✔
|
✔
|
|
Query
navigation (document outline)
|
✔
|
✔
|
✔
|
|
Show popup with
column name in the
values area for
INSERT statement
|
✔
|
✔
|
✔
|
|
Get Row Count
|
✔
|
✔
|
✔
|
|
Expanding
sp_executesql
|
✔
|
✔
|
✔
|
|
Named Regions
|
✔
|
✔
|
✔
|
|
Data
Sensitivity Classification
suggestions
|
✔
|
✔
|
✔
|
|
SSDT Project
|
✔
|
✔
|
✔
|
|
|
Enterprise
|
Professional
|
Standard
|
|
T-SQL
Formatting
|
|
|
|
|
SQL formatting
|
✔
|
✔
|
✔
|
|
SQL formatting
with a wide set of
options and
customizable formatting
styles
|
✔
|
✔
|
✔
|
|
Database
identifier case
synchronization
|
✔
|
✔
|
✔
|
|
Individual word
recognition in
CamelCase
identifiers
|
✔
|
✔
|
✔
|
|
Automatically
format on paste
|
✔
|
✔
|
✔
|
|
Database letter
case coherence
(formatting
with the dictionary)
|
✔
|
✔
|
✔
|
|
Word
recognition in CamelCase
identifiers
|
✔
|
✔
|
✔
|
|
Automatically
format completed
statement on
delimiter
|
✔
|
✔
|
✔
|
|
Formatting in
files and directories
|
✔
|
✔
|
✔
|
|
Disable formatting
for a certain block
of code
(noformat tag)
|
✔
|
✔
|
✔
|
|
Adjust keyword
case on typing
|
✔
|
✔
|
✔
|
|
Disable
formatting for a block of code
(noformat tag)
|
✔
|
✔
|
✔
|
|
Wide range of
predefined formatting
profiles
|
✔
|
✔
|
✔
|
|
SQL Formatting
command-line
interface
|
✔
|
✔
|
Ⅹ
|
|
CLI Wizard for
SQL Formatting
|
✔
|
✔
|
✔
|
|
|
Enterprise
|
Professional
|
Standard
|
|
T-SQL Code
Analyzer
|
|
|
|
|
Check T-SQL
code for compliance with
best practices
|
✔
|
Ⅹ
|
Ⅹ
|
|
Customize code
analysis profiles
|
✔
|
Ⅹ
|
Ⅹ
|
|
|
Enterprise
|
Professional
|
Standard
|
|
Code
Refactoring
|
|
|
|
|
Refactoring
aliases and custom alias
mapping
|
✔
|
✔
|
Ⅹ
|
|
Renaming
objects and variables
|
✔
|
✔
|
Ⅹ
|
|
Enclosing
needed identifiers in square
brackets
|
✔
|
✔
|
Ⅹ
|
|
Smart rename
|
✔
|
✔
|
Ⅹ
|
|
Semicolon
insertion
|
✔
|
✔
|
Ⅹ
|
|
T-SQL Debugger
|
✔
|
✔
|
Ⅹ
|
|
Find invalid
objects
|
✔
|
✔
|
Ⅹ
|
|
Find Invalid
Objects command-line
interface
|
✔
|
✔
|
Ⅹ
|
|
CLI Wizard for
Find Invalid Objects
|
✔
|
✔
|
✔
|
|
|
Enterprise
|
Professional
|
Standard
|
|
Productivity
Extension
|
|
|
|
|
Query History
|
✔
|
✔
|
✔
|
|
Execute current
statement
|
✔
|
✔
|
✔
|
|
Execute to
cursor
|
✔
|
✔
|
✔
|
|
Decrypt
encrypted objects
|
✔
|
✔
|
Ⅹ
|
|
Go to
definition for database objects
|
✔
|
✔
|
Ⅹ
|
|
Jump between
queries
|
✔
|
✔
|
Ⅹ
|
|
Jump between
BEGIN and END
|
✔
|
✔
|
Ⅹ
|
|
"Go to
definition" for database objects
|
✔
|
✔
|
Ⅹ
|
|
Document outline
window
|
✔
|
✔
|
Ⅹ
|
|
Statement
navigation
|
✔
|
✔
|
Ⅹ
|
|
Execution
warnings
|
✔
|
✔
|
Ⅹ
|
|
CRUD generator
|
✔
|
✔
|
Ⅹ
|
|
Inline EXEC
|
✔
|
✔
|
Ⅹ
|
|
Convert EXEC to
script (Stored
Procedure
Expansion)
|
✔
|
✔
|
Ⅹ
|
|
Run script on
multiple databases
|
✔
|
✔
|
Ⅹ
|
|
Import and
Export Settings (Wizard)
|
✔
|
✔
|
✔
|
|
Execution
notifications
|
✔
|
✔
|
Ⅹ
|
|
Transaction
reminder
|
✔
|
✔
|
Ⅹ
|
|
Find in Results
Grid
|
✔
|
✔
|
Ⅹ
|
|
Grid Aggregates
|
✔
|
✔
|
Ⅹ
|
|
Copy Data As
from the SSMS grid to
Excel and CSV
|
✔
|
✔
|
Ⅹ
|
|
Data visualizers
in Results Grid
|
✔
|
✔
|
Ⅹ
|
|
Navigation
between the BEGIN and
END pair
|
✔
|
✔
|
Ⅹ
|
|
Navigation
between BEGIN TRY/END
TRY
|
✔
|
✔
|
Ⅹ
|
|
Navigation
between BEGIN
CATCH/END CATCH
|
✔
|
✔
|
Ⅹ
|
|
Navigation
between CASE and END
|
✔
|
✔
|
Ⅹ
|
|
Navigation between
COLUMNS and
VALUES in the
INSERT statement
|
✔
|
✔
|
Ⅹ
|
|
Generate Script
As from SSMS data
grid
|
✔
|
✔
|
Ⅹ
|
|
Restore last
document session
|
✔
|
✔
|
Ⅹ
|
|
Restore last
closed tab
|
✔
|
✔
|
Ⅹ
|
|
Custom SSMS
main window title &
SQL document
tabs caption
|
✔
|
✔
|
Ⅹ
|
|
Close unmodified
tabs
|
✔
|
✔
|
Ⅹ
|
|
Tabs coloring
as well as Status bar
and Object
explorer coloring
|
✔
|
✔
|
Ⅹ
|
|
Script object
as CREATE/ALTER
|
✔
|
✔
|
Ⅹ
|
|
Excluding
databases from prompts
|
✔
|
✔
|
Ⅹ
|
|
Copy Results
Grid Headers (Column
Names + Types)
|
✔
|
✔
|
Ⅹ
|
|
Results Grid
Data Visualizers
|
✔
|
✔
|
Ⅹ
|
|
Proportional
tab width and the ability
to control what
is displayed in the tab
name
|
✔
|
✔
|
Ⅹ
|
|
|
Enterprise
|
Professional
|
Standard
|
|
Automation
|
|
|
|
|
SQL Formatting
command-line
interface
|
✔
|
✔
|
Ⅹ
|
|
CLI Wizard for
SQL Formatting
|
✔
|
✔
|
✔
|
|
Find Invalid
Objects command-line
interface
|
✔
|
✔
|
Ⅹ
|
|
CLI Wizard for
Find Invalid Objects
|
✔
|
✔
|
✔
|
