Mots réservés (SQL Server Compact)
SQL Server Compact possède des mots réservés que vous ne pouvez pas utiliser pour les noms de tables et de colonnes.
Utilisation des mots réservés
Un mot réservé dans SQL Server Compact ne fonctionne pas nécessairement de la même manière que le mot correspondant dans SQL Server. Le tableau ci-dessous répertorie les mots réservés dans SQL Server Compact.
Important
Évitez d'utiliser des mots réservés en guise d'identificateurs. Si vous devez utiliser des mots réservés comme identificateurs, délimitez-les par des guillemets doubles ou des crochets : []..
@@IDENTITY |
ENCRYPTION |
ORDER |
ADD |
END |
OUTER |
ALL |
ERRLVL |
OVER |
ALTER |
ESCAPE |
PERCENT |
AND |
EXCEPT |
PLAN |
ANY |
EXEC |
PRECISION |
AS |
EXECUTE |
PRIMARY |
ASC |
EXISTS |
|
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 |