Reserved words in queries
The following table lists SQL keywords that are reserved
in ColdFusion queries of queries. This list includes all reserved
words in the SQL standard. Avoid them in variables used in all queries.
Do not use these keywords as variable names in any queries.
Note: Many database management systems have additional
reserved words that you cannot use as variable names in queries
to their databases. For a detailed list, see your DBMS documentation.
ABSOLUTE
|
ACTION
|
ADD
|
ALL
|
ALLOCATE
|
ALTER
|
AND
|
ANY
|
ARE
|
AS
|
ASC
|
ASSERTION
|
AT
|
AUTHORIZATION
|
AVG
|
BEGIN
|
BETWEEN
|
BIT
|
BIT_LENGTH
|
BOTH
|
BY
|
CASCADE
|
CASCADED
|
CASE
|
CAST
|
CATALOG
|
CHAR
|
CHARACTER
|
CHARACTER_LENGTH
|
CHAR_LENGTH
|
CHECK
|
CLOSE
|
COALESCE
|
COLLATE
|
COLLATION
|
COLUMN
|
COMMIT
|
|
|
|
| |
|
CONNECT
|
CONNECTION
|
CONSTRAINT
|
CONSTRAINTS
|
CONTINUE
|
CONVERT
|
CORRESPONDING
|
COUNT
|
CREATE
|
CROSS
|
CURRENT
|
CURRENT_DATE
|
CURRENT_TIME
|
CURRENT_TIMESTAMP
|
CURRENT_USER
|
CURSOR
|
DATE
|
DAY
|
DEALLOCATE
|
DEC
|
DECIMAL
|
DECLARE
|
DEFAULT
|
DEFERRABLE
|
DEFERRED
|
DELETE
|
DESC
|
DESCRIBE
|
DESCRIPTOR
|
DIAGNOSTICS
|
DISCONNECT
|
DISTINCT
|
DOMAIN
|
DOUBLE
|
DROP
|
ELSE
|
END
|
END-EXEC
|
ESCAPE
|
EXCEPT
|
EXCEPTION
|
EXEC
|
EXECUTE
|
EXISTS
|
EXTERNAL
|
EXTRACT
|
FALSE
|
FETCH
|
FIRST
|
FLOAT
|
FOR
|
FOREIGN
|
FOUND
|
FROM
|
FULL
|
GET
|
GLOBAL
|
GO
|
GOTO
|
GRANT
|
GROUP
|
HAVING
|
HOUR
|
IDENTITY
|
IMMEDIATE
|
|
IN
|
|
| |
|
|
INDICATOR
|
INITIALLY
|
INNER
|
INPUT
|
INSENSITIVE
|
INSERT
|
INT
|
| |
|
|
|
|
INTEGER
|
INTERSECT
|
INTERVAL
|
INTO
|
IS
|
ISOLATION
|
JOIN
|
KEY
|
LANGUAGE
|
LAST
|
LEADING
|
LEFT
|
LEVEL
|
LIKE
|
LOCAL
|
LOWER
|
MATCH
|
MAX
|
MIN
|
MINUTE
|
MODULE
|
MONTH
|
NAMES
|
NATIONAL
|
NATURAL
|
NCHAR
|
NEXT
|
NO
|
NOT
|
NULL
|
NULLIF
|
NUMERIC
|
OCTET_LENGTH
|
OF
|
ON
|
ONLY
|
OPEN
|
OPTION
|
OR
|
ORDER
|
OUTER
|
OUTPUT
|
OVERLAPS
|
PAD
|
|
PARTIAL
|
|
|
|
|
POSITION
|
PRECISION
|
PREPARE
|
PRESERVE
|
PRIMARY
|
PRIOR
|
PRIVILEGES
|
PROCEDURE
|
PUBLIC
|
READ
|
REAL
|
REFERENCES
|
RELATIVE
|
RESTRICT
|
REVOKE
|
RIGHT
|
ROLLBACK
|
ROWS
|
SCHEMA
|
SCROLL
|
SECOND
|
SECTION
|
SELECT
|
SESSION
|
SESSION_USER
|
SET
|
SIZE
|
SMALLINT
|
SOME
|
SPACE
|
SQL
|
SQLCODE
|
SQLERROR
|
SQLSTATE
|
SUBSTRING
|
SUM
|
SYSTEM_USER
|
TABLE
|
TEMPORARY
|
THEN
|
TIME
|
TIMESTAMP
|
TIMEZONE_HOUR
|
TIMEZONE_MINUTE
|
TO
|
TRAILING
|
TRANSACTION
|
TRANSLATE
|
TRANSLATION
|
TRIM
|
TRUE
|
UNION
|
UNIQUE
|
UNKNOWN
|
UPDATE
|
UPPER
|
USAGE
|
USER
|
USING
|
VALUE
|
VALUES
|
VARCHAR
|
VARYING
|
VIEW
|
WHEN
|
WHENEVER
|
WHERE
|
WITH
|
WORK
|
WRITE
|
YEAR
|
ZONE
|
|
|
|
