保留字 (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 協助