DB2 Server for VSE & VM: Interactive SQL Guide and Reference


SQL Reserved Words

The following words are reserved in the SQL language. They cannot be used in SQL statements except for their defined meaning in the SQL syntax or as host variables, preceded by a colon.

In particular, they cannot be used as names for tables, indexes, columns, views, or dbspaces unless they are enclosed in double quotation marks (").



ACQUIRE
ADD
ALL
ALTER
AND
ANY
AS
ASC
AVG
 
BETWEEN
BY
 
CALL
CHAR
CHARACTER
COLUMN
COMMENT
COMMIT
CONCAT
CONNECT
COUNT
CREATE
CURRENT
 
DBA
DBSPACE
DELETE
DESC
DISTINCT
DOUBLE
DROP
 
EXCLUSIVE
EXECUTE
EXISTS
EXPLAIN
 
FIELDPROC
FOR
FROM


GRANT
GRAPHIC
GROUP
 
HAVING
 
IDENTIFIED
IN
INDEX
INSERT
INTO
IS
 
LIKE
LOCK
LONG
 
MAX
MIN
MODE
 
NAMED
NHEADER
NOT
NULL
 
OF
ON
OPTION
OR
ORDER
 
PACKAGE
PAGE
PAGES
PCTFREE
PCTINDEX
PRIVATE
PRIVILEGES
PROGRAM
PUBLIC


RESOURCE
REVOKE
ROLLBACK
ROW
RUN
 
SCHEDULE
SELECT
SET
SHARE
SOME
STATISTICS
STORPOOL
SUM
SYNONYM
 
TABLE
TO
 
UNION
UNIQUE
UPDATE
USER
 
VALUES
VIEW
 
WHERE
WITH
WORK


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]