萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> SQL Server 教學

SQL Server 保留關鍵字完整對照表 (含 ODBC 與未來保留字)

SQL Server 保留關鍵字 (Transact-SQL)

這些關鍵字屬於 T-SQL 語法一部分,若用作識別碼 (資料表名、欄位名等) 必須使用分隔識別符 (方括號 `[]` 或雙引號 `""` 配合 `QUOTED_IDENTIFIER ON`)。

ADD          EXCEPT       PERCENT
ALL          EXEC         PLAN
ALTER        EXECUTE      PRECISION
AND          EXISTS       PRIMARY
ANY          EXIT         PRINT
AS           FETCH        PROC
ASC          FILE         PROCEDURE
AUTHORIZATION FILLFACTOR  PUBLIC
BACKUP       FOR          RAISERROR
BEGIN        FOREIGN      READ
BETWEEN      FREETEXT     READTEXT
BREAK        FREETEXTTABLE RECONFIGURE
BROWSE       FROM         REFERENCES
BULK         FULL         REPLICATION
BY           FUNCTION     RESTORE
CASCADE      GOTO         RESTRICT
CASE         GRANT        RETURN
CHECK        GROUP        REVOKE
CHECKPOINT   HAVING       RIGHT
CLOSE        HOLDLOCK     ROLLBACK
CLUSTERED    IDENTITY     ROWCOUNT
COALESCE     IDENTITY_INSERT ROWGUIDCOL
COLLATE      IDENTITYCOL  RULE
COLUMN       IF           SAVE
COMMIT       IN           SCHEMA
COMPUTE      INDEX        SELECT
CONSTRAINT   INNER        SESSION_USER
CONTAINS     INSERT       SET
CONTAINSTABLE INTERSECT   SETUSER
CONTINUE     INTO         SHUTDOWN
CONVERT      IS           SOME
CREATE       JOIN         STATISTICS
CROSS        KEY          SYSTEM_USER
CURRENT      KILL         TABLE
CURRENT_DATE LEFT         TEXTSIZE
CURRENT_TIME LIKE         THEN
CURRENT_TIMESTAMP LINENO    TO
CURRENT_USER LOAD         TOP
CURSOR       NATIONAL     TRAN
DATABASE     NOCHECK      TRANSACTION
DBCC         NONCLUSTERED TRIGGER
DEALLOCATE   NOT          TRUNCATE
DECLARE      NULL         TSEQUAL
DEFAULT      NULLIF       UNION
DELETE       OF           UNIQUE
DENY         OFF          UPDATE
DESC         OFFSETS      UPDATETEXT
DISK         ON           USE
DISTINCT     OPEN         USER
DISTRIBUTED  OPENDATASOURCE VALUES
DOUBLE       OPENQUERY    VARYING
DROP         OPENROWSET   VIEW
DUMMY        OPENXML      WAITFOR
DUMP         OPTION       WHEN
ELSE         OR           WHERE
END          ORDER        WHILE
ERRLVL       OUTER        WITH
ESCAPE       OVER         WRITETEXT

ODBC 保留關鍵字

ODBC API 保留,雖不限制 SQL 語法,但為相容性應避免作為識別碼。列表與 SQL-92 標準一致。

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         ORDER       WORK
END-EXEC    OR          WRITE
ESCAPE      OUTER       YEAR
EXCEPT      OUTPUT      ZONE
EXCEPTION

未來可能保留的關鍵字

微軟保留擴充用,請勿作為識別碼使用。

ABSOLUTE    FOUND       PRESERVE
ACTION      FREE        PRIOR
ADMIN       GENERAL     PRIVILEGES
AFTER       GET         READS
AGGREGATE   GLOBAL      REAL
ALIAS       GO          RECURSIVE
ALLOCATE    GROUPING    REF
ARE         HOST        REFERENCING
ARRAY       HOUR        RELATIVE
ASSERTION   IGNORE      RESULT
AT          IMMEDIATE   RETURNS
BEFORE      INDICATOR   ROLE
BINARY      INITIALIZE  ROLLUP
BIT         INITIALLY   ROUTINE
BLOB        INOUT       ROW
BOOLEAN     INPUT       ROWS
BOTH        INT         SAVEPOINT
BREADTH     INTEGER     SCROLL
CALL        INTERVAL    SCOPE
CASCADED    ISOLATION   SEARCH
CAST        ITERATE     SECOND
CATALOG     LANGUAGE    SECTION
CHAR        LARGE       SEQUENCE
CHARACTER   LAST        SESSION
CLASS       LATERAL     SETS
CLOB        LEADING     SIZE
COLLATION   LESS        SMALLINT
COMPLETION  LEVEL       SPACE
CONNECT     LIMIT       SPECIFIC
CONNECTION  LOCAL       SPECIFICTYPE
CONSTRAINTS LOCALTIME   SQL
CONSTRUCTOR LOCALTIMESTAMP SQLEXCEPTION
CORRESPONDING LOCATOR    SQLSTATE
CUBE        MAP         SQLWARNING
CURRENT_PATH MATCH      START
... (更多請參閱官方文件)

最佳實務建議

  • 命名物件時盡量避開所有上述關鍵字。
  • 若必須使用,請全程以 `[識別碼]` 包裹。
  • 變數 (`@var`)、參數 (`@param`) 不受保留字限制,但為可讀性仍建議避開。
  • 使用工具 (如 SSMS IntelliSense、SQL Prompt) 可即時偵測關鍵字衝突。
copyright © 萬盛學電腦網 all rights reserved