The SQL standard specifies a huge number of keywords which may not be used as the names of tables, indices, columns, databases, user-defined functions, collations, virtual table modules, or any other named object. The list of keywords is so long that few people can remember them all. For most SQL code, your safest bet is to never use any English language word as the name of a user-defined object.
-
A
- ABORT
- ACTION
- ADD
- AFTER
- ALL
- ALTER
- ANALYZE
- AND
- AS
- ASC
- ATTACH
- AUTOINCREMENT
-
B
- BEFORE
- BEGIN
- BETWEEN
- BY
-
C
- CASCADE
- CASE
- CAST
- CHECK
- COLLATE
- COLUMN
- COMMIT
- CONFLICT
- CONSTRAINT
- CREATE
- CROSS
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
-
D
- DATABASE
- DEFAULT
- DEFERRABLE
- DEFERRED
- DELETE
- DESC
- DETACH
- DISTINCT
- DROP
-
E
- EACH
- ELSE
- END
- ESCAPE
- EXCEPT
- EXCLUSIVE
- EXISTS
- EXPLAIN
-
F
- FAIL
- FOR
- FOREIGN
- FROM
- FULL
-
G
- GLOB
- GROUP
-
H
- HAVING
-
I
- IF
- IGNORE
- IMMEDIATE
- IN
- INDEX
- INDEXED
- INITIALLY
- INNER
- INSERT
- INSTEAD
- INTERSECT
- INTO
- IS
- ISNULL
-
J
- JOIN
-
K
- KEY
-
L
- LEFT
- LIKE
- LIMIT
-
M
- MATCH
-
N
- NATURAL
- NO
- NOT
- NOTNULL
- NULL
-
O
- OF
- OFFSET
- ON
- OR
- ORDER
- OUTER
-
P
- PLAN
- PRAGMA
- PRIMARY
-
Q
- QUERY
-
R
- RAISE
- RECURSIVE
- REFERENCES
- REGEXP
- REINDEX
- RELEASE
- RENAME
- REPLACE
- RESTRICT
- RIGHT
- ROLLBACK
- ROW
-
S
- SAVEPOINT
- SELECT
- SET
-
T
- TABLE
- TEMP
- TEMPORARY
- THEN
- TO
- TRANSACTION
- TRIGGER
-
U
- UNION
- UNIQUE
- UPDATE
- USING
-
V
- VACUUM
- VALUES
- VIEW
- VIRTUAL
-
W
- WHEN
- WHERE
- WITH
- WITHOUT