SQL Server reserved words
Structured Query Language (SQL) is a programming language used to communicate with a database. Within SQL, certain words are reserved, which means you cannot use these words as an SQL identifier (such as the name for a table, a column, an AS alias, or other entity).
Reserved words in SQL Server
SQL reserved words | ||||
---|---|---|---|---|
ABSOLUTE | CURRENT_USER | GROUP | ON | SOME |
ACTION | CURSOR | HAVING | ONLY | SPACE |
ADA | DATABASE | HOLDLOCK | OPEN | SQL |
ADD | DATE | HOUR | OPENDATASOURCE | SQLCA |
ALL | DAY | IDENTITY | OPENQUERY | SQLCODE |
ALLOCATE | DBCC | IDENTITY_INSERT | OPENROWSET | SQLERROR |
ALTER | DEALLOCATE | IDENTITYCOL | OPENXML | SQLSTATE |
AND | DEC | IF | OPTION | SQLWARNING |
ANY | DECIMAL | IMMEDIATE | OR | STATISTICS |
ARE | DECLARE | IN | ORDER | SUBSTRING |
AS | DEFAULT | INCLUDE | OUTER | SUM |
ASC | DEFERRABLE | INDEX | OUTPUT | SYSTEM_USER |
ASSERTION | DEFERRED | INDICATOR | OVER | TABLE |
AT | DELETE | INITIALLY | OVERLAPS | TASKSTATUS |
AUTHORIZATION | DENY | INNER | PAD | TEMPORARY |
AVG | DESC | INPUT | PARTIAL | TEXTSIZE |
BACKUP | DESCRIBE | INSENSITIVE | PASCAL | THEN |
BEGIN | DESCRIPTOR | INSERT | PERCENT | TIME |
BETWEEN | DIAGNOSTICS | INT | PLAN | TIMESTAMP |
BIT | DISCONNECT | INTEGER | POSITION | TIMEZONE_HOUR |
BIT_LENGTH | DISK | INTERSECT | PRECISION | TIMEZONE_MINUTE |
BOTH | DISTINCT | INTERVAL | PREPARE | TO |
BREAK | DISTRIBUTED | INTO | PRESERVE | TOP |
BROWSE | DOMAIN | IS | PRIMARY | TRAILING |
BULK | DOUBLE | ISOLATION | TRAN | |
BY | DROP | JOIN | PRIOR | TRANSACTION |
CASCADE | DUMMY | KEY | PRIVILEGES | TRANSLATE |
CASCADED | DUMP | KILL | PROC | TRANSLATION |
CASE | ELSE | LANGUAGE | PROCEDURE | TRIGGER |
CAST | END | LAST | PUBLIC | TRIM |
CATALOG | END-EXEC | LEADING | RAISERROR | TRUE |
CHAR | ERRLVL | LEFT | READ | TRUNCATE |
CHAR_LENGTH | ESCAPE | LEVEL | READTEXT | TSEQUAL |
CHARACTER | EXCEPT | LIKE | REAL | UNION |
CHARACTER_LENGTH | EXCEPTION | LINENO | RECONFIGURE | UNIQUE |
CHECK | EXEC | LOAD | REFERENCES | UNKNOWN |
CHECKPOINT | EXECUTE | LOCAL | RELATIVE | UPDATE |
CLOSE | EXISTS | LOWER | REPLICATION | UPDATETEXT |
CLUSTERED | EXIT | MATCH | RESTORE | UPPER |
COALESCE | EXTERNAL | MAX | RESTRICT | USAGE |
COLLATE | EXTRACT | MIN | RETURN | USE |
COLLATION | FALSE | MINUTE | REVOKE | USER |
COLUMN | FETCH | MODULE | RIGHT | USING |
COMMIT | FILE | MONTH | ROLLBACK | VALUE |
COMPUTE | FILLFACTOR | NAMES | ROWCOUNT | VALUES |
CONNECT | FIRST | NATIONAL | ROWGUIDCOL | VARCHAR |
CONNECTION | FLOAT | NATURAL | ROWS | VARYING |
CONSTRAINT | FOR | NCHAR | RULE | VIEW |
CONSTRAINTS | FOREIGN | NEXT | SAVE | WAITFOR |
CONTAINS | FORTRAN | NO | SCHEMA | WHEN |
CONTAINSTABLE | FOUND | NOCHECK | SCROLL | WHENEVER |
CONTINUE | FREETEXT | NONCLUSTERED | SECOND | WHERE |
CONVERT | FREETEXTTABLE | NONE | SECTION | WHILE |
CORRESPONDING | FROM | NOT | SELECT | WITH |
COUNT | FULL | NULL | SESSION | WORK |
CREATE | FUNCTION | NULLIF | SESSION_USER | WRITE |
CROSS | GET | NUMERIC | SET | WRITETEXT |
CURRENT | GLOBAL | OCTET_LENGTH | SETUSER | YEAR |
CURRENT_DATE | GO | OF | SHUTDOWN | ZONE |
CURRENT_TIME | GOTO | OFF | SIZE | |
CURRENT_TIMESTAMP | GRANT | OFFSETS | SMALLINT |
Related Articles
InTechnical resources
InFundamentals of Blue
InTechnical resources
InData sync tool (DST) guide
Back to top