home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: InfoMgt
/
InfoMgt.zip
/
dbup208.zip
/
SQLWORDS.TXT
< prev
Wrap
Text File
|
1998-02-11
|
7KB
|
338 lines
This following list includes the SQL keywords defined in the ISO/ANS SQL92
standard plus additional words reserved in various dialects of SQL used by
different database products.
To preserve the portability of data between database systems, these words
should not be used as table or column names.
ABSOLUTE
ACQUIRE
ACTION
ADA
ADD
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
AT
AUDIT
AUTHORIZATION
AVG
BEGIN
BETWEEN
BIT
BIT_LENGTH
BOTH
BUFFERPOOL
BY
CALL
CAPTURE
CASCADED
CASE
CAST
CATALOG
CCSID
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CLOSE
CLUSTER
COALASCE
COLLATE
COLLATION
COLLECTION
COLUMN
COMMENT
COMMIT
CONCAT
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_SERVER
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_USER
CURSOR
DATABASE
DATE
DAY
DAYS
DBA
DBSPACE
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DISCONNECT
DISTINCT
DOMAIN
DOUBLE
DROP
EDITPROC
ELSE
END
END-EXEC
ERASE
ESCAPE
EXCEPT
EXCEPTION
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXPLAIN
EXTERNAL
EXTRACT
FALSE
FETCH
FIELDPROC
FIRST
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FROM
FULL
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
HAVING
HOUR
HOURS
IDENTIFIED
IDENTITY
IMMEDIATE
IN
INDEX
INDICATOR
INITIALLY
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTERVAL
INTO
IS
ISOLATION
JOIN
KEY
LABEL
LANGUAGE
LAST
LEADING
LEFT
LEVEL
LIKE
LOCAL
LOCK
LOCKSIZE
LONG
LOWER
MATCH
MAX
MICROSECOND
MICROSECONDS
MIN
MINUTE
MINUTES
MODE
MODULE
MONTH
MONTHS
NAMED
NAMES
NATIONAL
NATURAL
NCHAR
NEXT
NHEADER
NO
NONE
NOT
NULL
NULLIF
NUMERIC
NUMPARTS
OBID
OCTET_LENGTH
OF
ON
ONLY
OPEN
OPTIMIZE
OPTION
OPTIONS
OR
ORDER
OUT
OUTER
OUTPUT
OVERLAPS
PACKAGE
PAD
PAGE
PAGES
PART
PARTIAL
PASCAL
PCTFREE
PCTINDEX
PLAN
POSITION
PRECISION
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIQTY
PRIVATE
PRIVILEGES
PROCEDURE
PROGRAM
PUBLIC
READ
REAL
REFERENCES
RELATIVE
RELEASE
RESET
RESOURCE
RESTRICT
REVOKE
RIGHT
ROLLBACK
ROW
ROWS
RRN
RUN
SCHEDULE
SCHEMA
SCROLL
SECOND
SECONDS
SECQTY
SECTION
SELECT
SESSION
SESSION_USER
SET
SHARE
SIMPLE
SIZE
SMALLINT
SOME
SPACE
SQL
SQLCA
SQLCODE
SQLERROR
SQLSTATE
SQLWARNING
STATISTICS
STOGROUP
STORPOOL
SUBPAGES
SUBSTRING
SUM
SYNONYM
SYSTEM_USER
TABLE
TABLESPACE
TEMPORARY
THEN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION
TRANSLATION
TRIM
TRUE
UNION
UNIQUE
UNKNOWN
UPDATE
UPPER
USAGE
USER
USING
VALIDPROC
VALUE
VALUES
VARCHAR
VARIABLE
VARYING
VCAT
VIEW
VOLUMES
WHEN
WHENEVER
WHERE
WITH
WORK
WRITE
YEAR
YEARS
ZONE