CREATE Statements (Transact-SQL)

2013-05-16

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.

In This Section

CREATE AGGREGATE	CREATE FULLTEXT INDEX	CREATE SEARCH PROPERTY LIST (Transact-SQL)
CREATE APPLICATION ROLE	CREATE FULLTEXT STOPLIST	CREATE SEQUENCE (Transact-SQL)
CREATE ASSEMBLY	CREATE FUNCTION	CREATE SERVER AUDIT
CREATE ASYMMETRIC KEY	CREATE INDEX	CREATE SERVER AUDIT SPECIFICATION
CREATE BROKER PRIORITY	CREATE LOGIN	CREATE SERVICE
CREATE CERTIFICATE	CREATE MASTER KEY	CREATE SPATIAL INDEX
CREATE COLUMNSTORE INDEX	CREATE MESSAGE TYPE	CREATE STATISTICS
CREATE CONTRACT	CREATE PARTITION FUNCTION	CREATE SYMMETRIC KEY
CREATE CREDENTIAL	CREATE PARTITION SCHEME	CREATE SYNONYM
CREATE CRYPTOGRAPHIC PROVIDER	CREATE PROCEDURE	CREATE TABLE
CREATE DATABASE	CREATE QUEUE	CREATE TRIGGER
CREATE DATABASE AUDIT SPECIFICATION	CREATE REMOTE SERVICE BINDING	CREATE TYPE
CREATE DATABASE ENCRYPTION KEY	CREATE RESOURCE POOL	CREATE USER
CREATE DEFAULT	CREATE ROLE	CREATE VIEW
CREATE ENDPOINT	CREATE ROUTE	CREATE WORKLOAD GROUP
CREATE EVENT NOTIFICATION	CREATE RULE	CREATE XML INDEX
CREATE EVENT SESSION	CREATE SCHEMA	CREATE XML SCHEMA COLLECTION
CREATE FULLTEXT CATALOG

See Also

Other Resources

ALTER Statements (Transact-SQL)

DROP Statements (Transact-SQL)