Mots clés réservés (programme d'installation)
Microsoft SQL Server 2005 utilise des mots clés réservés pour définir, manipuler des bases de données et y accéder. Les mots clés réservés font partie de la grammaire de Transact-SQL, qui est utilisée par SQL Server pour analyser et comprendre les instructions et les lots Transact-SQL.
Les noms des instances SQL Server ne doivent pas correspondre à un mot clé réservé. Si tel est le cas, le programme d'installation rencontre une erreur. Aidez-vous du tableau suivant pour vous assurer que les mots clés réservés ne sont pas utilisés dans les noms des instances SQL Server 2005.
ADD |
EXCEPT |
PERCENT |
ALL |
EXEC |
PLAN |
ALTER |
EXECUTE |
PRECISION |
AND |
EXISTS |
PRIMARY |
ANY |
EXIT |
|
AS |
FETCH |
PROC |
ASC |
FILE |
PROCEDURE |
AUTHORIZATION |
FILLFACTOR |
PUBLIC |
BACKUP |
FOR |
RAISERROR |
BEGIN |
FOREIGN |
READ |
BETWEEN |
FREETEXT |
READTEXT |
BREAK |
FREETEXTTABLE |
RECONFIGURE |
BROWSE |
FROM |
REFERENCES |
BULK |
FULL |
REPLICATION |
BY |
FUNCTION |
RESTORE |
CASCADE |
GOTO |
RESTRICT |
CASE |
GRANT |
RETURN |
CHECK |
GROUP |
REVOKE |
CHECKPOINT |
HAVING |
RIGHT |
CLOSE |
HOLDLOCK |
ROLLBACK |
CLUSTERED |
IDENTITY |
ROWCOUNT |
COALESCE |
IDENTITY_INSERT |
ROWGUIDCOL |
COLLATE |
IDENTITYCOL |
RULE |
COLUMN |
IF |
SAVE |
COMMIT |
IN |
SCHEMA |
COMPUTE |
INDEX |
SELECT |
CONSTRAINT |
INNER |
SESSION_USER |
CONTAINS |
INSERT |
SET |
CONTAINSTABLE |
INTERSECT |
SETUSER |
CONTINUE |
INTO |
SHUTDOWN |
CONVERT |
IS |
SOME |
CREATE |
JOIN |
STATISTICS |
CROSS |
KEY |
SYSTEM_USER |
CURRENT |
KILL |
TABLE |
CURRENT_DATE |
LEFT |
TEXTSIZE |
CURRENT_TIME |
LIKE |
THEN |
CURRENT_TIMESTAMP |
LINENO |
TO |
CURRENT_USER |
LOAD |
TOP |
CURSOR |
NATIONAL |
TRAN |
DATABASE |
NOCHECK |
TRANSACTION |
DBCC |
NONCLUSTERED |
TRIGGER |
DEALLOCATE |
NOT |
TRUNCATE |
DECLARE |
NULL |
TSEQUAL |
DEFAULT |
NULLIF |
UNION |
DELETE |
OF |
UNIQUE |
DENY |
OFF |
UPDATE |
DESC |
OFFSETS |
UPDATETEXT |
DISK |
ON |
USE |
DISTINCT |
OPEN |
USER |
DISTRIBUTED |
OPENDATASOURCE |
VALUES |
DOUBLE |
OPENQUERY |
VARYING |
DROP |
OPENROWSET |
VIEW |
DUMMY |
OPENXML |
WAITFOR |
DUMP |
OPTION |
WHEN |
ELSE |
OR |
WHERE |
END |
ORDER |
WHILE |
ERRLVL |
OUTER |
WITH |
ESCAPE |
OVER |
WRITETEXT |
En outre, la norme SQL-2003 standard définit une liste de mots clés réservés. Évitez d'utiliser des mots clés réservés SQL-2003 pour des identificateurs et des noms d'objets. La liste des mots clés réservés ODBC fournie dans le tableau qui suit est identique à celle des mots clés réservés SQL-2003.
Remarque : |
---|
La liste des mots clés réservés SQL-2003 peut s'avérer parfois plus restrictive que celle de SQL Server et parfois moins restrictive. Par exemple, la liste des mots clés réservés SQL-2003 contient INT. SQL Server ne traite pas INT comme un mot clé réservé. |
Mots clés réservés ODBC
Les mots suivants sont réservés et utilisés dans les appels de fonctions ODBC. Ces mots ne limitent pas la grammaire minimale SQL ; cependant, pour garantir la compatibilité avec les pilotes qui gèrent la grammaire SQL de base, il est préférable de ne pas utiliser ces mots clés dans les noms d'instance SQL Server.
ABSOLUTE |
EXEC |
OVERLAPS |
ACTION |
EXECUTE |
PAD |
ADA |
EXISTS |
PARTIAL |
ADD |
EXTERNAL |
PASCAL |
ALL |
EXTRACT |
POSITION |
ALLOCATE |
FALSE |
PRECISION |
ALTER |
FETCH |
PREPARE |
AND |
FIRST |
PRESERVE |
ANY |
FLOAT |
PRIMARY |
ARE |
FOR |
PRIOR |
AS |
FOREIGN |
PRIVILEGES |
ASC |
FORTRAN |
PROCEDURE |
ASSERTION |
FOUND |
PUBLIC |
AT |
FROM |
READ |
AUTHORIZATION |
FULL |
REAL |
AVG |
GET |
REFERENCES |
BEGIN |
GLOBAL |
RELATIVE |
BETWEEN |
GO |
RESTRICT |
BIT |
GOTO |
REVOKE |
BIT_LENGTH |
GRANT |
RIGHT |
BOTH |
GROUP |
ROLLBACK |
BY |
HAVING |
ROWS |
CASCADE |
HOUR |
SCHEMA |
CASCADED |
IDENTITY |
SCROLL |
CASE |
IMMEDIATE |
SECOND |
CAST |
IN |
SECTION |
CATALOG |
INCLUDE |
SELECT |
CHAR |
INDEX |
SESSION |
CHAR_LENGTH |
INDICATOR |
SESSION_USER |
CHARACTER |
INITIALLY |
SET |
CHARACTER_LENGTH |
INNER |
SIZE |
CHECK |
INPUT |
SMALLINT |
CLOSE |
INSENSITIVE |
SOME |
COALESCE |
INSERT |
SPACE |
COLLATE |
INT |
SQL |
COLLATION |
INTEGER |
SQLCA |
COLUMN |
INTERSECT |
SQLCODE |
COMMIT |
INTERVAL |
SQLERROR |
CONNECT |
INTO |
SQLSTATE |
CONNECTION |
IS |
SQLWARNING |
CONSTRAINT |
ISOLATION |
SUBSTRING |
CONSTRAINTS |
JOIN |
SUM |
CONTINUE |
KEY |
SYSTEM_USER |
CONVERT |
LANGUAGE |
TABLE |
CORRESPONDING |
LAST |
TEMPORARY |
COUNT |
LEADING |
THEN |
CREATE |
LEFT |
TIME |
CROSS |
LEVEL |
TIMESTAMP |
CURRENT |
LIKE |
TIMEZONE_HOUR |
CURRENT_DATE |
LOCAL |
TIMEZONE_MINUTE |
CURRENT_TIME |
LOWER |
TO |
CURRENT_TIMESTAMP |
MATCH |
TRAILING |
CURRENT_USER |
MAX |
TRANSACTION |
CURSOR |
MIN |
TRANSLATE |
DATE |
MINUTE |
TRANSLATION |
DAY |
MODULE |
TRIM |
DEALLOCATE |
MONTH |
TRUE |
DEC |
NAMES |
UNION |
DECIMAL |
NATIONAL |
UNIQUE |
DECLARE |
NATURAL |
UNKNOWN |
DEFAULT |
NCHAR |
UPDATE |
DEFERRABLE |
NEXT |
UPPER |
DEFERRED |
NO |
USAGE |
DELETE |
NONE |
USER |
DESC |
NOT |
USING |
DESCRIBE |
NULL |
VALUE |
DESCRIPTOR |
NULLIF |
VALUES |
DIAGNOSTICS |
NUMERIC |
VARCHAR |
DISCONNECT |
OCTET_LENGTH |
VARYING |
DISTINCT |
OF |
VIEW |
DOMAIN |
ON |
WHEN |
DOUBLE |
ONLY |
WHENEVER |
DROP |
OPEN |
WHERE |
ELSE |
OPTION |
WITH |
END |
OR |
WORK |
END-EXEC |
ORDER |
WRITE |
ESCAPE |
OUTER |
YEAR |
EXCEPT |
OUTPUT |
ZONE |
EXCEPTION |
|
|
Mots clés futurs
Les mots clés suivants sont susceptibles d'être réservés dans les futures versions de SQL Server, lorsque de nouvelles fonctionnalités seront implémentées. Évitez d'utiliser ces mots dans les noms des instances SQL Server.
ABSOLUTE |
FOUND |
PREPARE |
ACTION |
FREE |
PRESERVE |
ADMIN |
FULLTEXTTABLE |
PRIOR |
AFTER |
GENERAL |
PRIVILEGES |
AGGREGATE |
GET |
READS |
ALIAS |
GLOBAL |
REAL |
ALLOCATE |
GO |
RECURSIVE |
ARE |
GROUPING |
REF |
ARRAY |
HOST |
REFERENCING |
ASSERTION |
HOUR |
RELATIVE |
AT |
IGNORE |
RESULT |
BEFORE |
IMMEDIATE |
RETURNS |
BINARY |
INDICATOR |
ROLE |
BIT |
INITIALIZE |
ROLLUP |
BLOB |
INITIALLY |
ROUTINE |
BOOLEAN |
INOUT |
ROW |
BOTH |
INPUT |
ROWS |
BREADTH |
INT |
SAVEPOINT |
CALL |
INTEGER |
SCROLL |
CASCADED |
INTERVAL |
SCOPE |
CAST |
ISOLATION |
SEARCH |
CATALOG |
ITERATE |
SECOND |
CHAR |
LANGUAGE |
SECTION |
CHARACTER |
LARGE |
SEQUENCE |
CLASS |
LAST |
SESSION |
CLOB |
LATERAL |
SETS |
COLLATION |
LEADING |
SIZE |
COMPLETION |
LESS |
SMALLINT |
CONNECT |
LEVEL |
SPACE |
CONNECTION |
LIMIT |
SPECIFIC |
CONSTRAINTS |
LOCAL |
SPECIFICTYPE |
CONSTRUCTOR |
LOCALTIME |
SQL |
CORRESPONDING |
LOCALTIMESTAMP |
SQLEXCEPTION |
CUBE |
LOCATOR |
SQLSTATE |
CURRENT_PATH |
MAP |
SQLWARNING |
CURRENT_ROLE |
MATCH |
START |
CYCLE |
MINUTE |
STATE |
DATA |
MODIFIES |
STATEMENT |
DATE |
MODIFY |
STATIC |
DAY |
MODULE |
STRUCTURE |
DEC |
MONTH |
TEMPORARY |
DECIMAL |
NAMES |
TERMINATE |
DEFERRABLE |
NATURAL |
THAN |
DEFERRED |
NCHAR |
TIME |
DEPTH |
NCLOB |
TIMESTAMP |
DEREF |
NEW |
TIMEZONE_HOUR |
DESCRIBE |
NEXT |
TIMEZONE_MINUTE |
DESCRIPTOR |
NO |
TRAILING |
DESTROY |
NONE |
TRANSLATION |
DESTRUCTOR |
NUMERIC |
TREAT |
DETERMINISTIC |
OBJECT |
TRUE |
DICTIONARY |
OLD |
UNDER |
DIAGNOSTICS |
ONLY |
UNKNOWN |
DISCONNECT |
OPERATION |
UNNEST |
DOMAIN |
ORDINALITY |
USAGE |
DYNAMIC |
OUT |
USING |
EACH |
OUTPUT |
VALUE |
END-EXEC |
PAD |
VARCHAR |
EQUALS |
PARAMETER |
VARIABLE |
EVERY |
PARAMETERS |
WHENEVER |
EXCEPTION |
PARTIAL |
WITHOUT |
EXTERNAL |
PATH |
WORK |
FALSE |
POSTFIX |
WRITE |
FIRST |
PREFIX |
YEAR |
FLOAT |
PREORDER |
ZONE |
Voir aussi
Tâches
Procédure : installer SQL Server 2005 (Programme d'installation)