| 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 |
Transact-SQL (T-SQL) statements for Analytic Platform System (APS) SQL Server Parallel Data Warehouse (PDW).
- 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
- DBCC DROPCLEANBUFFERS
- DBCC FREEPROCCACHE
- DBCC SHRINKLOG
- DBCC PDW_SHOWEXECUTIONPLAN
- DBCC PDW_SHOWPARTITIONSTATS
- DBCC PDW_SHOWSPACEUSED
- DBCC SHOW_STATISTICS
- 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
- 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
For more reference information, see T-SQL language elements and T-SQL system views.