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