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 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
