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 SERVER AUDIT
ALTER BROKER PRIORITY
ALTER FUNCTION
ALTER SERVER AUDIT SPECIFICATION
ALTER CERTIFICATE
ALTER INDEX
ALTER SERVICE
ALTER CREDENTIAL
ALTER LOGIN
ALTER SERVICE MASTER KEY
ALTER CRYPTOGRAPHIC PROVIDER
ALTER MASTER KEY
ALTER SYMMETRIC KEY
ALTER DATABASE
ALTER MESSAGE TYPE
ALTER TABLE
ALTER DATABASE AUDIT SPECIFICATION
ALTER PARTITION FUNCTION
ALTER TRIGGER
ALTER DATABASE Compatibility Level
ALTER PARTITION SCHEME
ALTER USER
ALTER DATABASE Database Mirroring
ALTER PROCEDURE
ALTER VIEW
ALTER DATABASE ENCRYPTION KEY
ALTER QUEUE
ALTER WORKLOAD GROUP
ALTER DATABASE File and Filegroup Options
ALTER REMOTE SERVICE BINDING
ALTER XML SCHEMA COLLECTION
ALTER DATABASE SET Options
ALTER RESOURCE GOVERNOR
ALTER ENDPOINT
ALTER RESOURCE POOL
