予約語 (SQL Server Compact Edition)

[アーティクル]
05/21/2007

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 のサポートについて