TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

ALTER 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 ALTER statements. Use ALTER statements to modify the definition of existing entities. For example, use ALTER TABLE to add a new column to a table, or use ALTER DATABASE to set database options.

ALTER APPLICATION ROLEALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)ALTER ROUTE
ALTER ASSEMBLYALTER EVENT SESSIONALTER SCHEMA
ALTER ASYMMETRIC KEYALTER EXTERNAL DATA SOURCEALTER SEARCH PROPERTY LIST (Transact-SQL)
ALTER AUTHORIZATIONALTER EXTERNAL RESOURCE POOLALTER SECURITY POLICY
ALTER AVAILABILITY GROUPALTER FULLTEXT CATALOGALTER SEQUENCE (Transact-SQL)
ALTER BROKER PRIORITYALTER FULLTEXT INDEXALTER SERVER AUDIT
ALTER CERTIFICATEALTER FULLTEXT STOPLISTALTER SERVER AUDIT SPECIFICATION
ALTER COLUMN ENCRYPTION KEYALTER FUNCTIONALTER SERVER CONFIGURATION
ALTER CREDENTIALALTER INDEXALTER SERVER ROLE
ALTER CRYPTOGRAPHIC PROVIDERALTER LOGINALTER SERVICE
ALTER DATABASEALTER MASTER KEYALTER SERVICE MASTER KEY
ALTER DATABASE AUDIT SPECIFICATIONALTER MESSAGE TYPEALTER SYMMETRIC KEY
ALTER DATABASE Compatibility LevelALTER PARTITION FUNCTIONALTER TABLE
ALTER DATABASE Database MirroringALTER PARTITION SCHEMEALTER TRIGGER
ALTER DATABASE ENCRYPTION KEYALTER PROCEDUREALTER USER
ALTER ENDPOINTALTER QUEUEALTER VIEW
ALTER DATABASE File and Filegroup OptionsALTER REMOTE SERVICE BINDINGALTER WORKLOAD GROUP
ALTER DATABASE SET HADRALTER RESOURCE GOVERNORALTER XML SCHEMA COLLECTION
ALTER DATABASE SET OptionsALTER RESOURCE POOL
ALTER DATABASE SCOPED CREDENTIAL (Transact-SQL)ALTER ROLE

CREATE Statements (Transact-SQL)
DROP Statements (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft