Palabras clave reservadas (programa de instalación)
SQL Server utiliza las palabras clave reservadas para definir, manipular y agregar bases de datos. Las palabras clave reservadas son parte de la gramática de Transact-SQL que usa SQL Server para analizar y comprender las instrucciones y lotes de Transact-SQL.
Los nombres de instancia de SQL Server no pueden coincidir con una palabra clave reservada. Utilice la siguiente tabla para asegurarse de que las palabras clave reservadas no se utilizan en los nombres de instancia de SQL Server.
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 |
Además, el estándar ISO define una lista de palabras clave reservadas. Evite utilizar las palabras clave reservadas de ISO como identificadores y nombres de objetos. La lista de palabras clave reservadas de ODBC (que se muestra en la tabla siguiente) es igual que la de ISO.
[!NOTA]
La lista de palabras clave reservadas de ISO puede ser unas veces más restrictiva que SQL Server y otras veces, menos. Por ejemplo, la lista de palabras clave reservadas de ISO contiene INT. SQL Server no considera INT una palabra clave reservada.
Palabras clave reservadas de ODBC
Las siguientes palabras están reservadas para su uso en llamadas a funciones de ODBC. Estas palabras no restringen la gramática mínima de SQL. Sin embargo, para garantizar la compatibilidad con los controladores que admiten la gramática básica de SQL, evite la utilización de estas palabras clave en nombres de instancias de 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 |
|
|