T-SQL statements supported in Azure SQL Data Warehouse

Data Definition Language (DDL) statements

• ALTER DATABASE
• ALTER INDEX
• ALTER MATERIALIZED VIEW (Preview)
• ALTER PROCEDURE
• ALTER SCHEMA
• ALTER TABLE
• CREATE COLUMNSTORE INDEX
• CREATE DATABASE
• CREATE DATABASE SCOPED CREDENTIAL
• CREATE EXTERNAL DATA SOURCE
• CREATE EXTERNAL FILE FORMAT
• CREATE EXTERNAL TABLE
• CREATE FUNCTION
• CREATE INDEX
• CREATE MATERIALIZED VIEW AS SELECT (Preview)
• CREATE PROCEDURE
• CREATE SCHEMA
• CREATE STATISTICS
• CREATE TABLE
• CREATE TABLE AS SELECT
• CREATE VIEW
• CREATE WORKLOAD CLASSIFIER
• DROP EXTERNAL DATA SOURCE
• DROP EXTERNAL FILE FORMAT
• DROP EXTERNAL TABLE
• DROP INDEX
• DROP PROCEDURE
• DROP STATISTICS
• DROP TABLE
• DROP SCHEMA
• DROP VIEW
• DROP WORKLOAD CLASSIFIER
• RENAME
• SET RESULT_SET_CACHING
• TRUNCATE TABLE
• UPDATE STATISTICS

Data Manipulation Language (DML) statements

• DELETE
• INSERT
• UPDATE

Database Console Commands

• DBCC DROPCLEANBUFFERS
• DBCC DROPRESULTSETCACHE (Preview)
• DBCC FREEPROCCACHE
• DBCC SHRINKLOG
• DBCC PDW_SHOWEXECUTIONPLAN
• DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD
• DBCC SHOWRESULTCACHESPACEUSED (Preview)
• DBCC PDW_SHOWPARTITIONSTATS
• DBCC PDW_SHOWSPACEUSED
• DBCC SHOW_STATISTICS

Query statements

• SELECT
• WITH common_table_expression
• EXCEPT and INTERSECT
• EXPLAIN
• FROM
• Using PIVOT and UNPIVOT
• GROUP BY
• HAVING
• ORDER BY
• OPTION
• UNION
• WHERE
• TOP
• Aliasing
• Search condition
• Subqueries

Security statements

• Permissions: GRANT, DENY, REVOKE
• ALTER AUTHORIZATION
• ALTER CERTIFICATE
• ALTER DATABASE ENCRYPTION KEY
• ALTER LOGIN
• ALTER MASTER KEY
• ALTER ROLE
• ALTER USER
• BACKUP CERTIFICATE
• CLOSE MASTER KEY
• CREATE CERTIFICATE
• CREATE DATABASE ENCRYPTION KEY
• CREATE LOGIN
• CREATE MASTER KEY
• CREATE ROLE
• CREATE USER
• DROP CERTIFICATE
• DROP DATABASE ENCRYPTION KEY
• DROP LOGIN
• DROP MASTER KEY
• DROP ROLE
• DROP USER
• OPEN MASTER KEY