T-SQL statements for Parallel Data Warehouse

Transact-SQL (T-SQL) statements for Analytic Platform System (APS) SQL Server Parallel Data Warehouse (PDW).

Data Definition Language (DDL) statements

• ALTER DATABASE
• ALTER INDEX
• 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 PROCEDURE
• CREATE SCHEMA
• CREATE STATISTICS
• CREATE TABLE
• CREATE TABLE AS SELECT
• CREATE VIEW
• DROP EXTERNAL DATA SOURCE
• DROP EXTERNAL FILE FORMAT
• DROP EXTERNAL TABLE
• DROP INDEX
• DROP PROCEDURE
• DROP STATISTICS
• DROP TABLE
• DROP SCHEMA
• DROP VIEW
• RENAME
• TRUNCATE TABLE
• UPDATE STATISTICS

Data Manipulation Language (DML) statements

• DELETE
• INSERT
• UPDATE

Database Console Commands

• DBCC DROPCLEANBUFFERS
• DBCC FREEPROCCACHE
• DBCC SHRINKLOG
• DBCC PDW_SHOWEXECUTIONPLAN
• 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

Next steps

For more reference information, see T-SQL language elements and T-SQL system views.