T-SQL 保留關鍵字完整清單：命名物件時必須避開的詞彙

關鍵字分類速查

撰寫 SQL 陳述式、預存程序、觸發器、資料行命名時，嚴禁使用以下保留關鍵字 作為識別碼（除非加上雙引號或方括號括起）。

A-B

ADD, ALL, ALTER, AND, ANY, AS, ASC, AUTHORIZATION, AVG,
BACKUP, BEGIN, BETWEEN, BREAK, BROWSE, BULK, BY,
CASCADE, CASE, CHECK, CHECKPOINT, CLOSE, CLUSTERED, COALESCE, COLUMN, COMMIT, COMPUTE,
CONSTRAINT, CONTAINS, CONTINUE, CONVERT, CREATE, CROSS, CURRENT, CURSOR

D-F

DATABASE, DBCC, DEALLOCATE, DECLARE, DEFAULT, DELETE, DENY, DESC, DISK, DISTINCT,
DISTRIBUTED, DOUBLE, DROP, DUMMY, DUMP,
ELSE, END, ERRLVL, ESCAPE, EXCEPT, EXEC, EXISTS, EXIT, EXTERNAL,
FETCH, FILE, FILLFACTOR, FOR, FOREIGN, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION

G-I

GOTO, GRANT, GROUP, HAVING, HOLDLOCK, IDENTITY, IDENTITY_INSERT, IDENTITYCOL, IF, IN,
INDEX, INNER, INSERT, INTERSECT, INTO, IS, JOIN, KEY, KILL, LEFT, LIKE, LINENO, LOAD

M-O

MERGE, MIRROR, NATIONAL, NOCHECK, NONCLUSTERED, NOT, NULL, NULLIF, OF, OFF, OFFSETS,
ON, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPENXML, OPTION, OR, ORDER, OUTER,
OVER, PERCENT, PIVOT, PLAN, PRECISION, PRIMARY, PRINT, PROC, PROCEDURE, PUBLIC

R-T

RAISERROR, READ, READTEXT, RECONFIGURE, REFERENCES, REPLICATION, RESTORE, RESTRICT,
RETURN, REVOKE, RIGHT, ROLLBACK, ROWCOUNT, ROWGUIDCOL, RULE, SAVE, SCHEMA, SELECT,
SEMANTICKEYPHRASETABLE, SEMANTICSIMILARITYDETAILSTABLE, SEMANTICSIMILARITYTABLE,
SESSION_USER, SET, SETUSER, SHUTDOWN, SOME, STATISTICS, SYSTEM_USER, TABLE, TABLESAMPLE,
TEXTSIZE, THEN, TO, TOP, TRAN, TRANSACTION, TRIGGER, TRUNCATE, TRY_CONVERT, TSEQUAL

U-Z

UNION, UNIQUE, UNPIVOT, UPDATE, UPDATETEXT, USE, USER, VALUES, VARYING, VIEW, WAITFOR,
WHEN, WHERE, WHILE, WITH, WITHIN, WORK, WRITE, XMLNAMESPACES

最佳命名慣例

1. 物件名稱採用 PascalCase：CustomerOrders、GetSalesReport。
2. 避免縮寫歧義，使用完整英文單字。
3. 若業務術語撞關鍵字，加上前綴：tbl_Order、col_Key。
4. 統一使用方括號包裹識別碼：[Order]、[Group]，相容性最佳。