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