保留字 (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 中的保留字。
.gif) 重要事项： |
|---|
| 避免将保留字用作标识符。如果保留字必须用作标识符，则必须用双引号进行分隔。 |
@@IDENTITY |
ENCRYPTION |
ORDER |
ADD |
END |
OUTER |
ALL |
ERRLVL |
OVER |
ALTER |
ESCAPE |
PERCENT |
AND |
EXCEPT |
PLAN |
ANY |
EXEC |
PRECISION |
AS |
EXECUTE |
PRIMARY |
ASC |
EXISTS |
|
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 |