Keywords

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 PRINT
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