SQL reserved words

This topic lists the Model 204 SQL reserved words, which are words that you cannot use as names of SQL objects.

This list includes standard and emerging standard SQL reserved words and Model 204 SQL proprietary reserved words (in bold italics).

Model 204 SQL reserved words

ADD ALL ALTER AND ANY AS ASC AUTHORIZATION AVG   BEGIN BETWEEN BLOB BY   CASCADE CAST CHAR CHARACTER CHECK CLOB CLOSE COBOL COMMIT CONTINUE COUNT CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURSOR

DEC DECIMAL DECLARE DEFAULT DELETE DESC DISTINCT DOUBLE DROP END ESCAPE EXEC EXISTS   FETCH FLOAT FOR FOREIGN FORTRAN FOUND FROM FULL   GO GOTO GRANT GROUP   HASH HAVING

IN INDEX INDICATOR INNER INSERT INT INTEGER INTO IS   JOIN   KEY   LANGUAGE LEFT LIKE   MAX MIN MODIFY MODULE   NATURAL NESTED NOT NULL NUM NUMERIC

OF ON OPEN OPTION OR ORDER ORDERED OUTER   PASCAL PLI POSITIONED PRECISION PRIMARY PRIVILEGES PROCEDURE PUBLIC   REAL REFERENCES RESTRICT REVOKE RIGHT ROLLBACK

SCHEMA SECTION SELECT SET SMALLINT SOME SORT SQL SQLCODE SQLERROR SQLSTATE SQLVERSION SUM SYSNAME SYSTEM   TABLE TO TYPE   UNCATALOG UNION UNIQUE UPDATE USER USING

VALUES VIEW   WHENEVER WHERE WITH WORK   GE LE NE

See also

• SQL Server overview
• SQL Server installation
• SQL catalog
• SQL representation of Model 204 data
• SQL Data Definition Language (DDL)
• SQL DDL from the Table Specification Facility
• SQL catalog reporting and querying
• SQL Data Manipulation Language (DML)
• SQL DDL syntax
• SQL reserved words
• SQL DDL mapping of the demonstration database