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.
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho