Pernyataan T-SQL didukung untuk kumpulan SQL khusus di Azure Synapse Analytics
Tautan ke dokumentasi pernyataan T-SQL yang didukung di kumpulan SQL khusus.
Pernyataan Bahasa Definisi Data (DDL)
- UBAH DATABASE
- ALTER INDEX
- ALTER MATERIALIZED VIEW (pratinjau)
- ALTER PROCEDURE
- ALTER SCHEMA
- ALTER TABLE
- CREATE COLUMNSTORE INDEX
- CREATE DATABASE
- CREATE DATABASE SCOPED CREDENTIAL
- CREATE EXTERNAL DATA SOURCE
- BUAT FORMAT FILE EKSTERNAL
- 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
Pernyataan Bahasa Manipulasi Data (DML)
Perintah Konsol Database
- DBCC DROPCLEANBUFFERS
- DBCC DROPRESULTSETCACHE (pratinjau)
- DBCC FREEPROCCACHE
- DBCC SHRINKLOG
- DBCC PDW_SHOWEXECUTIONPLAN
- DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD
- DBCC SHOWRESULTCACHESPACEUSED (preview)
- DBCC PDW_SHOWPARTITIONSTATS
- DBCC PDW_SHOWSPACEUSED
- DBCC SHOW_STATISTICS
Pernyataan kueri
- 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
- Subkueri
Pernyataan keamanan
Izin:
ALTER CERTIFICATE (pratinjau)
ALTER DATABASE ENCRYPTION KEY (pratinjau)
BACKUP CERTIFICATE (pratinjau)
CREATE CERTIFICATE (preview)
CREATE DATABASE ENCRYPTION KEY (preview)
DROP CERTIFICATE (preview)
Langkah berikutnya
Untuk informasi referensi lebih lanjut, lihat Elemen bahasa T-SQL di kumpulan SQL khusus, dan Tampilan sistem di kumpulan SQL khusus.