--- title: T-SQL statements description: T-SQL statements for Analytic Platform System (APS) SQL Server Parallel Data Warehouse (PDW). author: charlesfeddersen ms.author: charlesf ms.reviewer: martinle ms.date: 04/17/2018 ms.prod: sql ms.technology: data-warehouse ms.topic: conceptual ms.custom: seo-dt-2019 --- # 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](../t-sql/statements/alter-database-transact-sql.md?view=aps-pdw-2016&preserve-view=true) * [ALTER INDEX](../t-sql/statements/alter-index-transact-sql.md) * [ALTER PROCEDURE](../t-sql/statements/alter-procedure-transact-sql.md) * [ALTER SCHEMA](../t-sql/statements/alter-schema-transact-sql.md) * [ALTER TABLE](../t-sql/statements/alter-table-transact-sql.md) * [CREATE COLUMNSTORE INDEX](../t-sql/statements/create-columnstore-index-transact-sql.md) * [CREATE DATABASE](../t-sql/statements/create-database-transact-sql.md?view=aps-pdw-2016&preserve-view=true) * [CREATE DATABASE SCOPED CREDENTIAL](../t-sql/statements/create-database-scoped-credential-transact-sql.md) * [CREATE EXTERNAL DATA SOURCE](../t-sql/statements/create-external-data-source-transact-sql.md) * [CREATE EXTERNAL FILE FORMAT](../t-sql/statements/create-external-file-format-transact-sql.md) * [CREATE EXTERNAL TABLE](../t-sql/statements/create-external-table-transact-sql.md) * [CREATE FUNCTION](../t-sql/statements/create-function-sql-data-warehouse.md) * [CREATE INDEX](../t-sql/statements/create-index-transact-sql.md) * [CREATE PROCEDURE](../t-sql/statements/create-procedure-transact-sql.md) * [CREATE SCHEMA](../t-sql/statements/create-schema-transact-sql.md) * [CREATE STATISTICS](../t-sql/statements/create-statistics-transact-sql.md) * [CREATE TABLE](../t-sql/statements/create-table-azure-sql-data-warehouse.md) * [CREATE TABLE AS SELECT](../t-sql/statements/create-table-as-select-azure-sql-data-warehouse.md) * [CREATE VIEW](../t-sql/statements/create-view-transact-sql.md) * [DROP EXTERNAL DATA SOURCE](../t-sql/statements/drop-external-data-source-transact-sql.md) * [DROP EXTERNAL FILE FORMAT](../t-sql/statements/drop-external-file-format-transact-sql.md) * [DROP EXTERNAL TABLE](../t-sql/statements/drop-external-table-transact-sql.md) * [DROP INDEX](../t-sql/statements/drop-index-transact-sql.md) * [DROP PROCEDURE](../t-sql/statements/drop-procedure-transact-sql.md) * [DROP STATISTICS](../t-sql/statements/drop-statistics-transact-sql.md) * [DROP TABLE](../t-sql/statements/drop-table-transact-sql.md) * [DROP SCHEMA](../t-sql/statements/drop-schema-transact-sql.md) * [DROP VIEW](../t-sql/statements/drop-view-transact-sql.md) * [RENAME](../t-sql/statements/rename-transact-sql.md) * [TRUNCATE TABLE](../t-sql/statements/truncate-table-transact-sql.md) * [UPDATE STATISTICS](../t-sql/statements/update-statistics-transact-sql.md) ## Data Manipulation Language (DML) statements * [DELETE](../t-sql/statements/delete-transact-sql.md) * [INSERT](../t-sql/statements/insert-transact-sql.md) * [UPDATE](../t-sql/queries/update-transact-sql.md) ## Database Console Commands * [DBCC DROPCLEANBUFFERS](../t-sql/database-console-commands/dbcc-dropcleanbuffers-transact-sql.md) * [DBCC FREEPROCCACHE](/previous-versions/sql/sql-server-2016/mt204018(v=sql.130)) * [DBCC SHRINKLOG](../t-sql/database-console-commands/dbcc-shrinklog-azure-sql-data-warehouse.md?view=aps-pdw-2016-au7&preserve-view=true) * [DBCC PDW_SHOWEXECUTIONPLAN](../t-sql/database-console-commands/dbcc-pdw-showexecutionplan-transact-sql.md?view=aps-pdw-2016-au7&preserve-view=true) * [DBCC PDW_SHOWPARTITIONSTATS](../t-sql/database-console-commands/dbcc-pdw-showpartitionstats-transact-sql.md?view=aps-pdw-2016-au7&preserve-view=true) * [DBCC PDW_SHOWSPACEUSED](../t-sql/database-console-commands/dbcc-pdw-showspaceused-transact-sql.md) * [DBCC SHOW_STATISTICS](../t-sql/database-console-commands/dbcc-show-statistics-transact-sql.md) ## Query statements * [SELECT](../t-sql/queries/select-transact-sql.md) * [WITH common_table_expression](../t-sql/queries/with-common-table-expression-transact-sql.md) * [EXCEPT and INTERSECT](../t-sql/language-elements/set-operators-except-and-intersect-transact-sql.md) * [EXPLAIN](../t-sql/queries/explain-transact-sql.md) * [FROM](../t-sql/queries/from-transact-sql.md) * [Using PIVOT and UNPIVOT](../t-sql/queries/from-using-pivot-and-unpivot.md) * [GROUP BY](../t-sql/queries/select-group-by-transact-sql.md) * [HAVING](../t-sql/queries/select-having-transact-sql.md) * [ORDER BY](../t-sql/queries/select-order-by-clause-transact-sql.md) * [OPTION](../t-sql/queries/option-clause-transact-sql.md) * [UNION](../t-sql/language-elements/set-operators-union-transact-sql.md) * [WHERE](../t-sql/queries/where-transact-sql.md) * [TOP](../t-sql/queries/top-transact-sql.md) * [Aliasing](../t-sql/queries/aliasing-azure-sql-data-warehouse-parallel-data-warehouse.md) * [Search condition](../t-sql/queries/search-condition-transact-sql.md) * [Subqueries](../t-sql/queries/subqueries-azure-sql-data-warehouse-parallel-data-warehouse.md) ## Security statements * Permissions: [GRANT](../t-sql/statements/grant-transact-sql.md), [DENY](../t-sql/statements/deny-transact-sql.md), [REVOKE](../t-sql/statements/revoke-transact-sql.md) * [ALTER AUTHORIZATION](../t-sql/statements/alter-authorization-transact-sql.md) * [ALTER CERTIFICATE](../t-sql/statements/alter-certificate-transact-sql.md) * [ALTER DATABASE ENCRYPTION KEY](../t-sql/statements/alter-database-encryption-key-transact-sql.md) * [ALTER LOGIN](../t-sql/statements/alter-login-transact-sql.md) * [ALTER MASTER KEY](../t-sql/statements/alter-master-key-transact-sql.md) * [ALTER ROLE](../t-sql/statements/alter-role-transact-sql.md) * [ALTER USER](../t-sql/statements/alter-user-transact-sql.md) * [BACKUP CERTIFICATE](../t-sql/statements/backup-certificate-transact-sql.md) * [CLOSE MASTER KEY](../t-sql/statements/close-master-key-transact-sql.md) * [CREATE CERTIFICATE](../t-sql/statements/create-certificate-transact-sql.md) * [CREATE DATABASE ENCRYPTION KEY](../t-sql/statements/create-database-encryption-key-transact-sql.md) * [CREATE LOGIN](../t-sql/statements/create-login-transact-sql.md) * [CREATE MASTER KEY](../t-sql/statements/create-master-key-transact-sql.md) * [CREATE ROLE](../t-sql/statements/create-role-transact-sql.md) * [CREATE USER](../t-sql/statements/create-user-transact-sql.md) * [DROP CERTIFICATE](../t-sql/statements/drop-certificate-transact-sql.md) * [DROP DATABASE ENCRYPTION KEY](../t-sql/statements/drop-database-encryption-key-transact-sql.md) * [DROP LOGIN](../t-sql/statements/drop-login-transact-sql.md) * [DROP MASTER KEY](../t-sql/statements/drop-master-key-transact-sql.md) * [DROP ROLE](../t-sql/statements/drop-role-transact-sql.md) * [DROP USER](../t-sql/statements/drop-user-transact-sql.md) * [OPEN MASTER KEY](../t-sql/statements/open-master-key-transact-sql.md) ## Next steps For more reference information, see [T-SQL language elements](tsql-language-elements.md) and [T-SQL system views](tsql-system-views.md).