Reserved Words (SQL Server Compact)

SQL Server Compact has reserved words that cannot be used for table and column names.

Using Reserved Words

A reserved word in SQL Server Compact does not necessarily function the same way as the corresponding word in SQL Server. The following table lists the reserved words in SQL Server Compact.

Important

Avoid using reserved words as identifiers. If reserved words must be used as identifiers, they must be delimited with double quotation marks or enclosed within brackets: [].

@@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