A reserved word in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) does not necessarily function the same way as the corresponding word in SQL Server 2000. The following table lists the reserved words used in SQL Server CE.
Important Avoid using reserved words as identifiers. If reserved words must be used as identifiers, they must be delimited with double quotation marks.
| @@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 |