Skip to content
This repository has been archived by the owner on Jan 3, 2022. It is now read-only.

SQL Reserved Words

tsutomi edited this page Dec 30, 2011 · 1 revision

This is a list of SQL reserved words: these cannot be set as identifiers for database objects (such as variables, columns, tables, constraints, etc.). An error will be thrown at the moment of parsing of a SQL command, if one of these words will be used as identifier.

First Char Reserved Word
A ALL, ALTER, AND, ANY, ARRAY, ARROW, AS, ASC
B BEGIN, BETWEEN, BY
C CASE, CHECK, COLUMNS, CREATE, CURRENT
D DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DISTINCT, DROP
E ELSE, END, EXCEPTION, EXCLUSIVE, EXISTS
F FETCH, FORM, FOR, FROM
G GOTO, GRANT, GROUP
H HAVING
I IDENTIFIED, IF, IN, INDEXES, INDEX, INSERT, INTERSECT, INTO, IS
L LIKE, LOCK
M MINUS, MODE
N NOT, NULL
O OF, ON, OR, ORDER
P PRIOR, PROCEDURE, PUBLIC
R RANGE, REVOKE
S SELECT, SIZE, SQL, START
T TABLE, THEN, TO
U UNION, UNIQUE, UPDATE
V VALUES, VIEW, VIEWS
W WHEN, WHERE