CREATE Statements (Transact-SQL)

 

Updated: May 2, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Transact-SQL contains the following CREATE statements. Use CREATE statements to define new entities. For example, use CREATE TABLE to add a new table to a database.

CREATE AGGREGATECREATE EXTERNAL DATA SOURCECREATE SCHEMA
CREATE APPLICATION ROLECREATE EXTERNAL FILE FORMATCREATE SEARCH PROPERTY LIST
CREATE ASSEMBLYCREATE EXTERNAL RESOURCE POOLCREATE SECURITY POLICY
CREATE ASYMMETRIC KEYCREATE EXTERNAL TABLECREATE SELECTIVE XML INDEX
CREATE AVAILABILITY GROUPCREATE EXTERNAL TABLE AS SELECTCREATE SEQUENCE
CREATE BROKER PRIORITYCREATE FULLTEXT CATALOGCREATE SERVER AUDIT
CREATE CERTIFICATECREATE FULLTEXT INDEXCREATE SERVER AUDIT SPECIFICATION
CREATE COLUMN ENCRYPTION KEYCREATE FULLTEXT STOPLISTCREATE SERVER ROLE
CREATE COLUMN MASTER KEY DEFINITIONCREATE FUNCTIONCREATE SERVICE
CREATE COLUMNSTORE INDEXCREATE FUNCTION (SQL Data Warehouse)CREATE SPATIAL INDEX
CREATE CONTRACTCREATE INDEXCREATE STATISTICS
CREATE CREDENTIALCREATE LOGINCREATE SYMMETRIC KEY
CREATE CRYPTOGRAPHIC PROVIDERCREATE MASTER KEYCREATE SYNONYM
CREATE DATABASE (Azure SQL Data Warehouse)CREATE MESSAGE TYPECREATE TABLE
CREATE DATABASE (Parallel Data Warehouse)CREATE PARTITION FUNCTIONCREATE TABLE (Azure SQL Database)
CREATE DATABASE (SQL Server)CREATE PARTITION SCHEMECREATE TABLE (Azure SQL Data Warehouse, Parallel Data Warehouse)
CREATE DATABASE (Azure SQL Database)CREATE PROCEDURECREATE TABLE AS SELECT (Azure SQL Data Warehouse)
CREATE DATABASE AUDIT SPECIFICATIONCREATE QUEUECREATE TRIGGER
CREATE DATABASE ENCRYPTION KEYCREATE REMOTE SERVICE BINDINGCREATE TYPE
CREATE DATABASE SCOPED CREDENTIALCREATE REMOTE TABLE AS SELECT (Parallel Data Warehouse)CREATE USER
CREATE DEFAULTCREATE RESOURCE POOLCREATE VIEW
CREATE ENDPOINTCREATE ROLECREATE WORKLOAD GROUP
CREATE EVENT NOTIFICATIONCREATE ROUTECREATE XML INDEX
CREATE EVENT SESSIONCREATE RULECREATE XML SCHEMA COLLECTION

ALTER Statements (Transact-SQL)
DROP Statements (Transact-SQL)

Community Additions

ADD
Show: