CREATE Statements (Transact-SQL)

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)

  • Last updated on