Overview ALTER APPLICATION ROLE ASSEMBLY ASYMMETRIC KEY AUTHORIZATION AVAILABILITY GROUP BROKER PRIORITY CERTIFICATE COLUMN ENCRYPTION KEY CREDENTIAL CRYPTOGRAPHIC PROVIDER DATABASE DATABASE (Azure SQL Database) DATABASE (Azure SQL Data Warehouse) DATABASE (Parallel Data Warehouse) DATABASE AUDIT SPECIFICATION DATABASE compatibility level DATABASE database mirroring DATABASE ENCRYPTION KEY DATABASE file and filegroup options DATABASE HADR DATABASE SCOPED CREDENTIAL DATABASE SCOPED CONFIGURATION DATABASE SET Options ENDPOINT EVENT SESSION EXTERNAL DATA SOURCE EXTERNAL LIBRARY EXTERNAL RESOURCE POOL FULLTEXT CATALOG FULLTEXT INDEX FULLTEXT STOPLIST FUNCTION INDEX INDEX (Selective XML Indexes) LOGIN MASTER KEY MESSAGE TYPE PARTITION FUNCTION PARTITION SCHEME PROCEDURE QUEUE REMOTE SERVICE BINDING RESOURCE GOVERNOR RESOURCE POOL ROLE ROUTE SCHEMA SEARCH PROPERTY LIST SECURITY POLICY SEQUENCE SERVER AUDIT SERVER AUDIT SPECIFICATION SERVER CONFIGURATION SERVER ROLE SERVICE SERVICE MASTER KEY SYMMETRIC KEY TABLE TABLE column_constraint TABLE column_definition TABLE computed_column_definition TABLE index_option TABLE table_constraint TRIGGER USER VIEW WORKLOAD GROUP XML SCHEMA COLLECTION Backup and restore BACKUP BACKUP CERTIFICATE BACKUP DATABASE (Parallel Data Warehouse) BACKUP MASTER KEY BACKUP SERVICE MASTER KEY RESTORE RESTORE statements RESTORE DATABASE (Parallel Data Warehouse) RESTORE arguments RESTORE FILELISTONLY RESTORE HEADERONLY RESTORE LABELONLY RESTORE MASTER KEY RESTORE REWINDONLY RESTORE VERIFYONLY BULK INSERT CREATE AGGREGATE APPLICATION ROLE ASSEMBLY ASYMMETRIC KEY AVAILABILITY GROUP BROKER PRIORITY CERTIFICATE COLUMNSTORE INDEX COLUMN ENCRYPTION KEY COLUMN MASTER KEY CONTRACT CREDENTIAL CRYPTOGRAPHIC PROVIDER DATABASE DATABASE (Azure SQL Database) DATABASE (Azure SQL Data Warehouse) DATABASE (Parallel Data Warehouse) DATABASE AUDIT SPECIFICATION DATABASE ENCRYPTION KEY DATABASE SCOPED CREDENTIAL DEFAULT ENDPOINT EVENT NOTIFICATION EVENT SESSION EXTERNAL DATA SOURCE EXTERNAL LIBRARY EXTERNAL FILE FORMAT EXTERNAL RESOURCE POOL EXTERNAL TABLE EXTERNAL TABLE AS SELECT FULLTEXT CATALOG FULLTEXT INDEX FULLTEXT STOPLIST FUNCTION FUNCTION (SQL Data Warehouse) INDEX LOGIN MASTER KEY MESSAGE TYPE PARTITION FUNCTION PARTITION SCHEME PROCEDURE QUEUE REMOTE SERVICE BINDING REMOTE TABLE AS SELECT (Parallel Data Warehouse) RESOURCE POOL ROLE ROUTE RULE SCHEMA SEARCH PROPERTY LIST SECURITY POLICY SELECTIVE XML INDEX SEQUENCE SERVER AUDIT SERVER AUDIT SPECIFICATION SERVER ROLE SERVICE SPATIAL INDEX STATISTICS SYMMETRIC KEY SYNONYM TABLE TABLE (Azure SQL Data Warehouse) TABLE (SQL Graph) TABLE AS SELECT (Azure SQL Data Warehouse) TABLE IDENTITY (Property) TRIGGER TYPE USER VIEW WORKLOAD GROUP XML INDEX XML INDEX (Selective XML Indexes) XML SCHEMA COLLECTION Collations COLLATE clause SQL Server Collation Name Windows Collation Name Collation Precedence DELETE DISABLE TRIGGER DROP AGGREGATE APPLICATION ROLE ASSEMBLY ASYMMETRIC KEY AVAILABILITY GROUP BROKER PRIORITY CERTIFICATE COLUMN ENCRYPTION KEY COLUMN MASTER KEY CONTRACT CREDENTIAL CRYPTOGRAPHIC PROVIDER DATABASE DATABASE AUDIT SPECIFICATION DATABASE ENCRYPTION KEY DATABASE SCOPED CREDENTIAL DEFAULT ENDPOINT EXTERNAL DATA SOURCE EXTERNAL FILE FORMAT EXTERNAL LIBRARY EXTERNAL RESOURCE POOL EXTERNAL TABLE EVENT NOTIFICATION EVENT SESSION FULLTEXT CATALOG FULLTEXT INDEX FULLTEXT STOPLIST FUNCTION INDEX INDEX (Selective XML Indexes) LOGIN MASTER KEY MESSAGE TYPE PARTITION FUNCTION PARTITION SCHEME PROCEDURE QUEUE REMOTE SERVICE BINDING RESOURCE POOL ROLE ROUTE RULE SCHEMA SEARCH PROPERTY LIST SECURITY POLICY SEQUENCE SERVER AUDIT SERVER AUDIT SPECIFICATION SERVER ROLE SERVICE SIGNATURE STATISTICS SYMMETRIC KEY SYNONYM TABLE TRIGGER TYPE USER VIEW WORKLOAD GROUP XML SCHEMA COLLECTION ENABLE TRIGGER INSERT INSERT (SQL Graph) MERGE RENAME Permissions ADD SIGNATURE CLOSE MASTER KEY CLOSE SYMMETRIC KEY DENY DENY Assembly Permissions DENY Asymmetric Key Permissions DENY Availability Group Permissions DENY Certificate Permissions DENY Database Permissions DENY Database Principal Permissions DENY Database Scoped Credential DENY Endpoint Permissions DENY Full-Text Permissions DENY Object Permissions DENY Schema Permissions DENY Search Property List Permissions DENY Server Permissions DENY Server Principal Permissions DENY Service Broker Permissions DENY Symmetric Key Permissions DENY System Object Permissions DENY Type Permissions DENY XML Schema Collection Permissions EXECUTE AS EXECUTE AS Clause GRANT GRANT Assembly Permissions GRANT Asymmetric Key Permissions GRANT Availability Group Permissions GRANT Certificate Permissions GRANT Database Permissions GRANT Database Principal Permissions GRANT Database Scoped Credential GRANT Endpoint Permissions GRANT Full-Text Permissions GRANT Object Permissions GRANT Schema Permissions GRANT Search Property List Permissions GRANT Server Permissions GRANT Server Principal Permissions GRANT Service Broker Permissions GRANT Symmetric Key Permissions GRANT System Object Permissions GRANT Type Permissions GRANT XML Schema Collection Permissions OPEN MASTER KEY OPEN SYMMETRIC KEY Permissions: GRANT, DENY, REVOKE (Azure SQL Data Warehouse, Parallel Data Warehouse) REVERT REVOKE REVOKE Assembly Permissions REVOKE Asymmetric Key Permissions REVOKE Availability Group Permissions REVOKE Certificate Permissions REVOKE Database Permissions REVOKE Database Principal Permissions REVOKE Database Scoped Credential REVOKE Endpoint Permissions REVOKE Full-Text Permissions REVOKE Object Permissions REVOKE Schema Permissions REVOKE Search Property List Permissions REVOKE Server Permissions REVOKE Server Principal Permissions REVOKE Service Broker Permissions REVOKE Symmetric Key Permissions REVOKE System Object Permissions REVOKE Type Permissions REVOKE XML Schema Collection Permissions SETUSER Service Broker BEGIN CONVERSATION TIMER BEGIN DIALOG CONVERSATION END CONVERSATION GET CONVERSATION GROUP GET_TRANSMISSION_STATUS MOVE CONVERSATION RECEIVE SEND SET Overview ANSI_DEFAULTS ANSI_NULL_DFLT_OFF ANSI_NULL_DFLT_ON ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT ARITHIGNORE CONCAT_NULL_YIELDS_NULL CONTEXT_INFO CURSOR_CLOSE_ON_COMMIT DATEFIRST DATEFORMAT DEADLOCK_PRIORITY FIPS_FLAGGER FMTONLY FORCEPLAN IDENTITY_INSERT IMPLICIT_TRANSACTIONS LANGUAGE LOCK_TIMEOUT NOCOUNT NOEXEC NUMERIC_ROUNDABORT OFFSETS PARSEONLY QUERY_GOVERNOR_COST_LIMIT QUOTED_IDENTIFIER REMOTE_PROC_TRANSACTIONS ROWCOUNT SHOWPLAN_ALL SHOWPLAN_TEXT SHOWPLAN_XML STATISTICS IO STATISTICS PROFILE STATISTICS TIME STATISTICS XML TEXTSIZE TRANSACTION ISOLATION LEVEL XACT_ABORT TRUNCATE TABLE UPDATE STATISTICS