ALTER 陳述式 (Transact-SQL)

SQL Server Transact-SQL 包含下列 ALTER 陳述式。使用 ALTER 陳述式可修改現有實體的定義。例如，使用 ALTER TABLE 將新的資料行加入至資料表中，或是使用 ALTER DATABASE 來設定資料庫選項。

本章節內容

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 相容性層級	ALTER PARTITION SCHEME	ALTER TABLE
ALTER DATABASE 資料庫鏡像	ALTER PROCEDURE	ALTER TRIGGER
ALTER DATABASE ENCRYPTION KEY	ALTER QUEUE	ALTER USER
ALTER DATABASE 檔案及檔案群組選項	ALTER REMOTE SERVICE BINDING	ALTER VIEW
ALTER DATABASE SET 選項	ALTER RESOURCE GOVERNOR	ALTER WORKLOAD GROUP
ALTER ENDPOINT	ALTER RESOURCE POOL	ALTER XML SCHEMA COLLECTION