T-SQL statements supported for dedicated SQL pool in Azure Synapse Analytics
Links to the documentation for T-SQL statements supported in dedicated SQL pool.
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
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:
ALTER CERTIFICATE (preview)
ALTER DATABASE ENCRYPTION KEY (preview)
BACKUP CERTIFICATE (preview)
CREATE CERTIFICATE (preview)
CREATE DATABASE ENCRYPTION KEY (preview)
DROP CERTIFICATE (preview)
Next steps
For more reference information, see T-SQL language elements in dedicated SQL pool, and System views in dedicated SQL pool.