https://msdn.microsoft.com/zh-cn/library/ms189822(v=sql.120).aspx
下表列出了 SQL Server 保留關鍵字。
|
add |
EXTERNAL |
PROCEDURE |
|
ALL |
FETCH |
PUBLIC |
|
ALTER |
FILE |
RAISERROR |
|
And |
FILLFACTOR |
READ |
|
ANY |
FOR |
READTEXT |
|
As |
FOREIGN |
RECONFIGURE |
|
ASC |
FREETEXT |
REFERENCES |
|
AUTHORIZATION |
FREETEXTTABLE |
REPLICATION |
|
BACKUP |
from |
RESTORE |
|
BEGIN |
FULL |
RESTRICT |
|
BETWEEN |
FUNCTION |
RETURN |
|
BREAK |
GOTO |
REVERT |
|
BROWSE |
GRANT |
REVOKE |
|
BULK |
GROUP |
RIGHT |
|
BY |
HAVING |
ROLLBACK |
|
CASCADE |
HOLDLOCK |
ROWCOUNT |
|
Case |
IDENTITY |
ROWGUIDCOL |
|
CHECK |
IDENTITY_INSERT |
RULE |
|
CHECKPOINT |
IDENTITYCOL |
SAVE |
|
close |
IF |
SCHEMA |
|
CLUSTERED |
IN |
SECURITYAUDIT |
|
COALESCE |
INDEX |
SELECT |
|
COLLATE |
INNER |
SEMANTICKEYPHRASETABLE |
|
COLUMN |
INSERT |
SEMANTICSIMILARITYDETAILSTABLE |
|
COMMIT |
INTERSECT |
SEMANTICSIMILARITYTABLE |
|
COMPUTE |
INTO |
SESSION_USER |
|
CONSTRAINT |
is |
SET |
|
CONTAINS |
JOIN |
SETUSER |
|
CONTAINSTABLE |
KEY |
SHUTDOWN |
|
CONTINUE |
KILL |
SOME |
|
CONVERT |
LEFT |
STATISTICS |
|
CREATE |
LIKE |
SYSTEM_USER |
|
CROSS |
LINENO |
TABLE |
|
CURRENT |
LOAD |
TABLESAMPLE |
|
CURRENT_DATE |
MERGE |
TEXTSIZE |
|
CURRENT_TIME |
NATIONAL |
THEN |
|
CURRENT_TIMESTAMP |
NOCHECK |
目標 |
|
CURRENT_USER |
NONCLUSTERED |
TOP |
|
CURSOR |
NOT |
TRAN |
|
DATABASE |
NULL |
TRANSACTION |
|
DBCC |
NULLIF |
Trigger |
|
DEALLOCATE |
OF |
TRUNCATE |
|
DECLARE |
OFF |
TRY_CONVERT |
|
DEFAULT |
OFFSETS |
TSEQUAL |
|
delete |
ON |
UNION |
|
DENY |
OPEN |
UNIQUE |
|
DESC |
OPENDATASOURCE |
UNPIVOT |
|
DISK |
OPENQUERY |
UPDATE |
|
DISTINCT |
OPENROWSET |
UPDATETEXT |
|
DISTRIBUTED |
OPENXML |
USE |
|
DOUBLE |
OPTION |
USER |
|
DROP |
OR |
VALUES |
|
DUMP |
ORDER |
VARYING |
|
Else |
OUTER |
View |
|
END |
OVER |
WAITFOR |
|
ERRLVL |
PERCENT |
WHEN |
|
ESCAPE |
PIVOT |
WHERE |
|
EXCEPT |
PLAN |
WHILE |
|
EXEC |
PRECISION |
WITH |
|
EXECUTE |
PRIMARY |
WITHIN GROUP |
|
EXISTS |
|
WRITETEXT |
|
EXIT |
PROC |
此外，ISO 標準定義了保留關鍵字列表。 不要使用 ISO 保留關鍵字作為物件名和識別符號。 ODBC 保留關鍵字列表（如下表所示）與 ISO 保留關鍵字列表相同。
 注意 |
|---|
|
ISO 標準保留關鍵字有時可能比 SQL Server 限制更多，有時則更少。 例如，ISO 保留關鍵字列表包含 INT。 SQL Server 不必將此區分為保留關鍵字。 |
Transact-SQL 保留關鍵字可用作資料庫或資料庫物件（如表、列、檢視等）的識別符號或名稱。 使用帶引號的識別符號或分隔識別符號。 不限制將保留關鍵字用作變數和儲存過程引數的名稱。
保留了下列關鍵字以用於 ODBC 函式呼叫。 這些關鍵字根本不約束 SQL 語法；然而，為確保與支援核心 SQL 語法的驅動程式相容，應用程式應避免使用這些關鍵字。
下面是當前的 ODBC 保留關鍵字列表。
|
ABSOLUTE |
EXEC |
OVERLAPS |
|
ACTION |
EXECUTE |
PAD |
|
ADA |
EXISTS |
PARTIAL |
|
ADD |
EXTERNAL |
PASCAL |
|
ALL |
EXTRACT |
POSITION |
|
ALLOCATE |
FALSE |
PRECISION |
|
ALTER |
FETCH |
PREPARE |
|
AND |
FIRST |
PRESERVE |
|
ANY |
FLOAT |
PRIMARY |
|
ARE |
FOR |
PRIOR |
|
AS |
FOREIGN |
PRIVILEGES |
|
ASC |
FORTRAN |
PROCEDURE |
|
ASSERTION |
FOUND |
PUBLIC |
|
AT |
FROM |
READ |
|
AUTHORIZATION |
FULL |
REAL |
|
AVG |
GET |
REFERENCES |
|
BEGIN |
GLOBAL |
RELATIVE |
|
BETWEEN |
GO |
RESTRICT |
|
BIT |
GOTO |
REVOKE |
|
BIT_LENGTH |
GRANT |
RIGHT |
|
BOTH |
GROUP |
ROLLBACK |
|
BY |
HAVING |
ROWS |
|
CASCADE |
HOUR |
SCHEMA |
|
CASCADED |
IDENTITY |
SCROLL |
|
CASE |
IMMEDIATE |
SECOND |
|
CAST |
IN |
SECTION |
|
CATALOG |
INCLUDE |
SELECT |
|
CHAR |
INDEX |
SESSION |
|
CHAR_LENGTH |
INDICATOR |
SESSION_USER |
|
CHARACTER |
INITIALLY |
SET |
|
CHARACTER_LENGTH |
INNER |
SIZE |
|
CHECK |
INPUT |
SMALLINT |
|
CLOSE |
INSENSITIVE |
SOME |
|
COALESCE |
INSERT |
SPACE |
|
COLLATE |
INT |
SQL |
|
COLLATION |
INTEGER |
SQLCA |
|
COLUMN |
INTERSECT |
SQLCODE |
|
COMMIT |
INTERVAL |
SQLERROR |
|
CONNECT |
INTO |
SQLSTATE |
|
CONNECTION |
IS |
SQLWARNING |
|
CONSTRAINT |
ISOLATION |
SUBSTRING |
|
CONSTRAINTS |
JOIN |
SUM |
|
CONTINUE |
KEY |
SYSTEM_USER |
|
CONVERT |
LANGUAGE |
TABLE |
|
CORRESPONDING |
LAST |
TEMPORARY |
|
COUNT |
LEADING |
THEN |
|
CREATE |
LEFT |
TIME |
|
CROSS |
LEVEL |
TIMESTAMP |
|
CURRENT |
LIKE |
TIMEZONE_HOUR |
|
CURRENT_DATE |
LOCAL |
TIMEZONE_MINUTE |
|
CURRENT_TIME |
LOWER |
TO |
|
CURRENT_TIMESTAMP |
MATCH |
TRAILING |
|
CURRENT_USER |
MAX |
TRANSACTION |
|
CURSOR |
MIN |
TRANSLATE |
|
DATE |
MINUTE |
TRANSLATION |
|
DAY |
MODULE |
TRIM |
|
DEALLOCATE |
MONTH |
TRUE |
|
DEC |
NAMES |
UNION |
|
DECIMAL |
NATIONAL |
UNIQUE |
|
DECLARE |
NATURAL |
UNKNOWN |
|
DEFAULT |
NCHAR |
UPDATE |
|
DEFERRABLE |
NEXT |
UPPER |
|
DEFERRED |
NO |
USAGE |
|
DELETE |
NONE |
USER |
|
DESC |
NOT |
USING |
|
DESCRIBE |
NULL |
VALUE |
|
DESCRIPTOR |
NULLIF |
VALUES |
|
DIAGNOSTICS |
NUMERIC |
VARCHAR |
|
DISCONNECT |
OCTET_LENGTH |
VARYING |
|
DISTINCT |
OF |
VIEW |
|
DOMAIN |
ON |
WHEN |
|
DOUBLE |
ONLY |
WHENEVER |
|
DROP |
OPEN |
WHERE |
|
ELSE |
OPTION |
WITH |
|
END |
OR |
WORK |
|
END-EXEC |
ORDER |
WRITE |
|
ESCAPE |
OUTER |
YEAR |
|
EXCEPT |
OUTPUT |
ZONE |
|
EXCEPTION |
|
|
下列關鍵字可能會在將來的 SQL Server 版本中保留使用，作為將來要實現的新功能。 注意，不要使用這些關鍵字作為識別符號。
|
ABSOLUTE |
HOST |
RELATIVE |
|
ACTION |
HOUR |
RELEASE |
|
ADMIN |
IGNORE |
RESULT |
|
AFTER |
IMMEDIATE |
RETURNS |
|
AGGREGATE |
INDICATOR |
ROLE |
|
Alias |
INITIALIZE |
ROLLUP |
|
ALLOCATE |
INITIALLY |
ROUTINE |
|
ARE |
INOUT |
ROW |
|
ARRAY |
INPUT |
ROWS |
|
ASENSITIVE |
INT |
SAVEPOINT |
|
ASSERTION |
INTEGER |
SCROLL |
|
ASYMMETRIC |
INTERSECTION |
SCOPE |
|
AT |
INTERVAL |
SEARCH |
|
ATOMIC |
ISOLATION |
SECOND |
|
BEFORE |
ITERATE |
SECTION |
|
BINARY |
LANGUAGE |
SENSITIVE |
|
BIT |
LARGE |
SEQUENCE |
|
BLOB |
LAST |
SESSION |
|
BOOLEAN |
LATERAL |
SETS |
|
BOTH |
LEADING |
SIMILAR |
|
BREADTH |
LESS |
SIZE |
|
CALL |
LEVEL |
SMALLINT |
|
CALLED |
LIKE_REGEX |
SPACE |
|
CARDINALITY |
LIMIT |
SPECIFIC |
|
CASCADED |
LN |
SPECIFICTYPE |
|
CAST |
LOCAL |
SQL |
|
CATALOG |
LOCALTIME |
SQLEXCEPTION |
|
CHAR |
LOCALTIMESTAMP |
SQLSTATE |
|
CHARACTER |
LOCATOR |
SQLWARNING |
|
CLASS |
MAP |
START |
|
CLOB |
MATCH |
狀態 |
|
COLLATION |
MEMBER |
STATEMENT |
|
COLLECT |
METHOD |
STATIC |
|
COMPLETION |
MINUTE |
STDDEV_POP |
|
CONDITION |
MOD |
STDDEV_SAMP |
|
CONNECT |
MODIFIES |
STRUCTURE |
|
CONNECTION |
MODIFY |
SUBMULTISET |
|
CONSTRAINTS |
MODULE |
SUBSTRING_REGEX |
|
CONSTRUCTOR |
MONTH |
SYMMETRIC |
|
CORR |
MULTISET |
SYSTEM |
|
CORRESPONDING |
NAMES |
TEMPORARY |
|
COVAR_POP |
NATURAL |
TERMINATE |
|
COVAR_SAMP |
NCHAR |
THAN |
|
CUBE |
NCLOB |
TIME |
|
CUME_DIST |
NEW |
TIMESTAMP |
|
CURRENT_CATALOG |
NEXT |
TIMEZONE_HOUR |
|
CURRENT_DEFAULT_TRANSFORM_GROUP |
NO |
TIMEZONE_MINUTE |
|
CURRENT_PATH |
NONE |
TRAILING |
|
CURRENT_ROLE |
NORMALIZE |
TRANSLATE_REGEX |
|
CURRENT_SCHEMA |
NUMERIC |
TRANSLATION |
|
CURRENT_TRANSFORM_GROUP_FOR_TYPE |
Object
|
TREAT |
|
CYCLE |
OCCURRENCES_REGEX |
TRUE |
|
DATA |
OLD |
UESCAPE |
|
DATE |
ONLY |
UNDER |
|
DAY |
OPERATION |
UNKNOWN |
|
DEC |
ORDINALITY |
UNNEST |
|
DECIMAL |
OUT |
USAGE |
|
DEFERRABLE |
OVERLAY |
USING |
|
DEFERRED |
OUTPUT |
Value |
|
DEPTH |
PAD |
VAR_POP |
|
DEREF |
引數 |
VAR_SAMP |
|
DESCRIBE |
PARAMETERS |
VARCHAR |
|
DESCRIPTOR |
PARTIAL |
VARIABLE |
|
DESTROY |
PARTITION |
WHENEVER |
|
DESTRUCTOR |
PATH |
WIDTH_BUCKET |
|
DETERMINISTIC |
POSTFIX |
WITHOUT |
|
DICTIONARY |
PREFIX |
WINDOW |
|
DIAGNOSTICS |
PREORDER |
WITHIN |
|
DISCONNECT |
PREPARE |
WORK |
|
DOMAIN |
PERCENT_RANK |
WRITE |
|
DYNAMIC |
PERCENTILE_CONT |
XMLAGG |
|
EACH |
PERCENTILE_DISC |
XMLATTRIBUTES |
|
ELEMENT |
POSITION_REGEX |
XMLBINARY |
|
END-EXEC |
PRESERVE |
XMLCAST |
|
EQUALS |
PRIOR |
XMLCOMMENT |
|
EVERY |
PRIVILEGES |
XMLCONCAT |
|
EXCEPTION |
RANGE |
XMLDOCUMENT |
|
FALSE |
READS |
XMLELEMENT |
|
FILTER |
REAL |
XMLEXISTS |
|
FIRST |
RECURSIVE |
XMLFOREST |
|
FLOAT |
REF |
XMLITERATE |
|
FOUND |
REFERENCING |
XMLNAMESPACES |
|
FREE |
REGR_AVGX |
XMLPARSE |
|
FULLTEXTTABLE |
REGR_AVGY |
XMLPI |
|
FUSION |
REGR_COUNT |
XMLQUERY |
|
GENERAL |
REGR_INTERCEPT |
XMLSERIALIZE |
|
GET |
REGR_R2 |
XMLTABLE |
|
GLOBAL |
REGR_SLOPE |
XMLTEXT |
|
GO |
REGR_SXX |
XMLVALIDATE |
|
GROUPING |
REGR_SXY |
YEAR |
|
HOLD |
REGR_SYY |
ZONE |