SQL Server
保留关键字
Microsoft® SQL Server™ 2000
使用保留关键字定义、操作和访问数据库。保留关键字是
SQL Server
使用的
Transact-SQL
语言语法的一部分,用于分析和理解
Transact-SQL
语句和批处理。尽管在
Transact-SQL
脚本中,使用
SQL Server
保留关键字作为标识符和对象名在语法上是可行的,但规定只能使用分隔标识符。
下表列出了
SQL Server
的保留关键字。
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
|
另外,
SQL-92
标准还定义了保留关键字列表。不要使用
SQL-92
保留关键字作为对象名和标识符。
ODBC
保留关键字列表(如下所示)与
SQL-92
保留关键字列表相同。
说明:
SQL-92
保留关键字列表有时可能比
SQL Server
限制更多,有时则限制更少。例如,
SQL-92
保留关键字列表包含
INT
,而
SQL Server
不需要将其区分为保留关键字。
Transact-SQL
保留关键字可用作数据库或数据库对象(如表、列、视图等)的标识符或名称。使用被引用的标识符或分隔标识符。对将保留关键字用作变量和存储过程参数的名称没有限制。