Following are lists of SQL Server keywords and reserved words. These are the SQL Server keywords. Keywords new for SQL Server 6.0 are shown in bold type.
ADD | ALL | ALTER |
AND | ANY | AS |
ASC | AVG | BEGIN |
BETWEEN | BREAK | BROWSE |
BULK | BY | CASE |
CHECK | CHECKPOINT | CLOSE |
CLUSTERED | COALESCE | COMMIT |
COMMITTED | COMPUTE | CONFIRM |
CONSTRAINT | CONTINUE | CONTROLROW |
CONVERT | COUNT | CREATE |
CURRENT | CURRENT_DATE | CURRENT_TIME |
CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
DATABASE | DBCC | DEALLOCATE |
DECLARE | DEFAULT | DELETE |
DESC | DISK | DISTINCT |
DOUBLE | DROP | DUMMY |
DUMP | ELSE | END |
ERRLVL | ERROREXIT | EXCEPT |
EXEC | EXECUTE | EXISTS |
EXIT | FETCH | FILLFACTOR |
FLOPPY | FOR | FOREIGN |
FROM | GOTO | GRANT |
GROUP | HAVING | HOLDLOCK |
IDENTITY | IDENTITY_INSERT | IDENTITYCOL |
IF | IN | INDEX |
INSENSITIVE | INSERT | INTERSECT |
INTO | IS | ISOLATION |
KEY | KILL | LEVEL |
LIKE | LINENO | LOAD |
MAX | MIN | MIRROREXIT |
NOCHECK | NONCLUSTERED | NOT |
NULL | NULLIF | OF |
OFF | OFFSETS | ON |
ONCE | ONLY | OPEN |
OPTION | OR | ORDER |
OVER | PERM | PERMANENT |
PIPE | PLAN | PRECISION |
PREPARE | PRIMARY | |
PROC | PROCEDURE | PROCESSEXIT |
PUBLIC | RAISERROR | READ |
RECONFIGURE | REFERENCES | REPEATABLE |
REPLICATION | RETURN | REVOKE |
ROLLBACK | ROWCOUNT | RULE |
SAVE | SCROLL | SELECT |
SERIALIZABLE | SESSION_USER | SET |
SETUSER | SHUTDOWN | SOME |
STATISTICS | SUM | SYSTEM_USER |
TABLE | TAPE | TEMP |
TEMPORARY | TEXTSIZE | THEN |
TO | TRAN | TRANSACTION |
TRIGGER | TRUNCATE | TSEQUAL |
UNCOMMITTED | UNION | UNIQUE |
UPDATE | UPDATETEXT | USE |
USER | VALUES | VARYING |
VIEW | WAITFOR | WHEN |
WHERE | WHILE | WITH |
WRITETEXT |