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 SERVER AUDIT
CREATE APPLICATION ROLE
CREATE FULLTEXT STOPLIST
CREATE SERVER AUDIT SPECIFICATION
CREATE ASSEMBLY
CREATE FUNCTION
CREATE SERVICE
CREATE ASYMMETRIC KEY
CREATE INDEX
CREATE SPATIAL INDEX
CREATE BROKER PRIORITY
CREATE LOGIN
CREATE STATISTICS
CREATE CERTIFICATE
CREATE MASTER KEY
CREATE SYMMETRIC KEY
CREATE CONTRACT
CREATE MESSAGE TYPE
CREATE SYNONYM
CREATE CREDENTIAL
CREATE PARTITION FUNCTION
CREATE TABLE
CREATE CRYPTOGRAPHIC PROVIDER
CREATE PARTITION SCHEME
CREATE TRIGGER
CREATE DATABASE
CREATE PROCEDURE
CREATE TYPE
CREATE DATABASE AUDIT SPECIFICATION
CREATE QUEUE
CREATE USER
CREATE DATABASE ENCRYPTION KEY
CREATE REMOTE SERVICE BINDING
CREATE VIEW
CREATE DEFAULT
CREATE RESOURCE POOL
CREATE WORKLOAD GROUP
CREATE ENDPOINT
CREATE ROLE
CREATE XML INDEX
CREATE EVENT NOTIFICATION
CREATE ROUTE
CREATE XML SCHEMA COLLECTION
CREATE EVENT SESSION
CREATE RULE
CREATE FULLTEXT CATALOG
CREATE SCHEMA