保留字 (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) 包含一些保留字,这些保留字不能用作表名称和列名称。

使用保留字

SQL Server Compact Edition 中的保留字用法未必和 SQL Server 2005 中对应的保留字用法相同。下表列出了 SQL Server Compact Edition 中的保留字。

重要事项:
避免将保留字用作标识符。如果保留字必须用作标识符,则必须用双引号进行分隔。

@@IDENTITY

ENCRYPTION

ORDER

ADD

END

OUTER

ALL

ERRLVL

OVER

ALTER

ESCAPE

PERCENT

AND

EXCEPT

PLAN

ANY

EXEC

PRECISION

AS

EXECUTE

PRIMARY

ASC

EXISTS

PRINT

AUTHORIZATION

EXIT

PROC

AVG

EXPRESSION

PROCEDURE

BACKUP

FETCH

PUBLIC

BEGIN

FILE

RAISERROR

BETWEEN

FILLFACTOR

READ

BREAK

FOR

READTEXT

BROWSE

FOREIGN

RECONFIGURE

BULK

FREETEXT

REFERENCES

BY

FREETEXTTABLE

REPLICATION

CASCADE

FROM

RESTORE

CASE

FULL

RESTRICT

CHECK

FUNCTION

RETURN

CHECKPOINT

GOTO

REVOKE

CLOSE

GRANT

RIGHT

CLUSTERED

GROUP

ROLLBACK

COALESCE

HAVING

ROWCOUNT

COLLATE

HOLDLOCK

ROWGUIDCOL

COLUMN

IDENTITY

RULE

COMMIT

IDENTITY_INSERT

SAVE

COMPUTE

IDENTITYCOL

SCHEMA

CONSTRAINT

IF

SELECT

CONTAINS

IN

SESSION_USER

CONTAINSTABLE

INDEX

SET

CONTINUE

INNER

SETUSER

CONVERT

INSERT

SHUTDOWN

COUNT

INTERSECT

SOME

CREATE

INTO

STATISTICS

CROSS

IS

SUM

CURRENT

JOIN

SYSTEM_USER

CURRENT_DATE

KEY

TABLE

CURRENT_TIME

KILL

TEXTSIZE

CURRENT_TIMESTAMP

LEFT

THEN

CURRENT_USER

LIKE

TO

CURSOR

LINENO

TOP

DATABASE

LOAD

TRAN

DATABASEPASSWORD

MAX

TRANSACTION

DATEADD

MIN

TRIGGER

DATEDIFF

NATIONAL

TRUNCATE

DATENAME

NOCHECK

TSEQUAL

DATEPART

NONCLUSTERED

UNION

DBCC

NOT

UNIQUE

DEALLOCATE

NULL

UPDATE

DECLARE

NULLIF

UPDATETEXT

DEFAULT

OF

USE

DELETE

OFF

USER

DENY

OFFSETS

VALUES

DESC

ON

VARYING

DISK

OPEN

VIEW

DISTINCT

OPENDATASOURCE

WAITFOR

DISTRIBUTED

OPENQUERY

WHEN

DOUBLE

OPENROWSET

WHERE

DROP

OPENXML

WHILE

DUMP

OPTION

WITH

ELSE

OR

WRITETEXT

请参阅

帮助和信息

获取 SQL Server Compact Edition 帮助