ALTER Statements (Transact-SQL)

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.

In This Section

ALTER APPLICATION ROLE

ALTER EVENT SESSION

ALTER ROLE

ALTER ASSEMBLY

ALTER FULLTEXT CATALOG

ALTER ROUTE

ALTER ASYMMETRIC KEY

ALTER FULLTEXT INDEX

ALTER SCHEMA

ALTER AUTHORIZATION

ALTER FULLTEXT STOPLIST

ALTER SEARCH PROPERTY LIST (Transact-SQL)

ALTER BROKER PRIORITY

ALTER FUNCTION

ALTER SEQUENCE (Transact-SQL)

ALTER CERTIFICATE

ALTER INDEX

ALTER SERVER AUDIT

ALTER CREDENTIAL

ALTER LOGIN

ALTER SERVER AUDIT SPECIFICATION

ALTER CRYPTOGRAPHIC PROVIDER

ALTER MASTER KEY

ALTER SERVICE

ALTER DATABASE

ALTER MESSAGE TYPE

ALTER SERVICE MASTER KEY

ALTER DATABASE AUDIT SPECIFICATION

ALTER PARTITION FUNCTION

ALTER SYMMETRIC KEY

ALTER DATABASE Compatibility Level

ALTER PARTITION SCHEME

ALTER TABLE

ALTER DATABASE Database Mirroring

ALTER PROCEDURE

ALTER TRIGGER

ALTER DATABASE ENCRYPTION KEY

ALTER QUEUE

ALTER USER

ALTER DATABASE File and Filegroup Options

ALTER REMOTE SERVICE BINDING

ALTER VIEW

ALTER DATABASE SET Options

ALTER RESOURCE GOVERNOR

ALTER WORKLOAD GROUP

ALTER ENDPOINT

ALTER RESOURCE POOL

ALTER XML SCHEMA COLLECTION

See Also

Other Resources

CREATE Statements (Transact-SQL)

DROP Statements (Transact-SQL)