The tables below display the keywords in the ANSI standard, and in the five platform-specific implementations of SQL that are discussed in this book, with the Sybase Adaptive Server. The keyword tables appear in the following order:
Shared keywords
SQL2003 keywords
DB2 keywords
MySQL keywords
Oracle keywords
PostgreSQL keywords
SQL Server keywords
Sybase Adaptive Server keywords
ADD
ALL
ALTER
AND
AS
ASC
BY
CHECK
COLUMN
CREATE
DATE
DEFAULT
DELETE
DESC
DROP
FOR
FROM
IN
INTO
IS
LIKE
NOT
NULL
ON
OR
ORDER
REVOKE
SELECT
SET
TABLE
THEN
TO
UNIQUE
UPDATE
WITH
ABSOLUTE
ACTION
ADMIN
AFTER
AGGREGATE
ALIAS
ALLOCATE
ANY
ARE
ARRAY
ASSERTION
AT
ATOMIC
AUTHORIZATION
BEFORE
BEGIN
BIGINT
BINARY
BIT
BLOB
BOOLEAN
BOTH
BREADTH
CALL
CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHARACTER
CLASS
CLOB
CLOSE
COLLATE
COLLATION
COLLECT
COMMIT
COMPLETION
CONDITION
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONSTRUCTOR
CONTAINS
CONTINUE
CORRESPONDING
CROSS
CUBE
CURRENT
CURRENT_DATE
CURRENT_PATH
CURRENT_ROLE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CYCLE
DATA
DATALINK
DAY
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFERRABLE
DEPTH
DEREF
DESCRIPTOR
DESTRUCTOR
DIAGNOSTICS
DICTIONARY
DISCONNECT
DO
DOMAIN
DOUBLE
ELEMENT
END-EXEC
EQUALS
ESCAPE
EXCEPT
EXCEPTION
EXECUTE
EXIT
EXPAND
EXPANDING
FALSE
FIRST
FLOAT
FOREIGN
FREE
FUNCTION
FUSION
GENERAL
GET
GLOBAL
GOTO
GROUP
GROUPING
HANDLER
HASH
HOUR
IDENTITY
IF
IGNORE
IMMEDIATE
INDICATOR
INITIALIZE
INITIALLY
INNER
INOUT
INPUT
INSERT
INT
INTEGER
INTERSECT
INTERSECTION
INTERVAL
ISOLATION
ITERATE
JOIN
KEY
LANGUAGE
LARGE
LAST
LATERAL
LEADING
LEAVE
LEFT
LESS
LEVEL
LIMIT
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATOR
LOOP
MATCH
MEMBER
MEETS
MERGE
MINUTE
MODIFIES
MODIFY
MODULE
MONTH
MULTISET
NAMES
NATIONAL
NATURAL
NCHAR
NCLOB
NEW
NEXT
NO
NONE
NORMALIZE
NUMERIC
OBJECT
OF
OFF
OLD
ONLY
OPEN
OPERATION
OPTION
ORDINALITY
OUT
OUTER
OUTPUT
PAD
PARAMETER
PARAMETERS
PARTIAL
PATH
PERIOD
POSTFIX
PRECEDES
PRECISION
PREFIX
PREORDER
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVILEGES
PROCEDURE
PUBLIC
READ
READS
REAL
RECURSIVE
REDO
REF
REFERENCES
REFERENCING
RELATIVE
REPEAT
RESIGNAL
RESTRICT
RESULT
RETURN
RETURNS
RIGHT
ROLE
ROLLBACK
ROLLUP
ROUTINE
ROW
ROWS
SAVEPOINT
SCHEMA
SCROLL
SEARCH
SECOND
SECTION
SEQUENCE
SESSION
SESSION_USER
SETS
SIGNAL
SIZE
SMALLINT
SPECIFIC
SPECIFICTYPE
SQL
SQLEXCEPTION
SQLSTATE
SQLWARNING
START
STATE
STATIC
STRUCTURE
SUBMULTISET
SUCCEEDS
SUM
SYSTEM_USER
TABLESAMPLE
TEMPORARY
TERMINATE
THAN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TRAILING
TRANSACTION
TRANSLATION
TREAT
TRIGGER
TRUE
UESCAPE
UNDER
UNDO
UNION
UNKNOWN
UNTIL
USAGE
USER
USING
VALUE
VALUES
VARCHAR
VARIABLE
VARYING
VIEW
WHEN
WHENEVER
WHERE
WHILE
WRITE
YEAR
ZONE
ACQUIRE
ALLOW
ASUTIME
AUDIT
AUXILIARY
AVG
BETWEEN
BUFFERPOOL
CALLED
CAPTURE
CCSID
CLUSTER
COLLECTION
COLLID
COMMENT
CONCAT
COUNT
COUNT_BIG
CURRENT_LC_PATH
CURRENT_SERVER
CURRENT_TIMEZONE
DATABASE
DAYS
DB2GENERAL
DB2SQL
DBA
DBINFO
DBSPACE
DETERMINISTIC
DISALLOW
DISTINCT
DSSIZE
DYNAMIC
EDITPROC
ELSE
ELSEIF
END
ERASE
EXCLUSIVE
EXISTS
EXPLAIN
EXTERNAL
FENCED
FETCH
FIELDPROC
FILE
FINAL
FULL
GENERATED
GO
GRANT
GRAPHIC
HAVING
HOURS
IDENTIFIED
INDEX
INSENSITIVE
INTEGRITY
ISOBID
JAVA
LABEL
LC_CTYPE
LINKTYPE
LOCALE
LOCATORS
LOCK
LOCKSIZE
LONG
MAX
MICROSECOND
MICROSECONDS
MIN
MINUTES
MODE
MONTHS
NAME
NAMED
NHEADER
NODENAME
NODENUMBER
NULLS
NUMPARTS
OBID
OPTIMIZATION
OPTIMIZE
PACKAGE
PAGE
PAGES
PART
PARTITION
PCTFREE
PCTINDEX
PIECESIZE
PLAN
POSITION
PRIQTY
PRIVATE
PROGRAM
PSID
QUERYNO
RECOVERY
RELEASE
RENAME
RESET
RESOURCE
RRN
RUN
SCHEDULE
SCRATCHPAD
SECONDS
SECQTY
SECURITY
SHARE
SIMPLE
SOME
SOURCE
STANDARD
STATISTICS
STAY
STOGROUP
STORES
STORPOOL
STYLE
SUBPAGES
SUBSTRING
SYNONYM
TABLESPACE
TRIM
TYPE
VALIDPROC
VARIANT
VCAT
VOLUMES
WLM
WORK
YEARS
AUTO_INCREMENT
AVG_ROW_LENGTH
BOOL
CHANGE
CHECKSUM
COLUMNS
DATABASES
DATETIME
DAY_HOUR
DAY_MINUTE
DAY_SECOND
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DELAY_KEY_WRITE
DELAYED
DESCRIBE
DISTINCTROW
ENCLOSED
ENUM
ESCAPED
FIELDS
FLOAT4
FLOAT8
FLUSH
GRANTS
HEAP
HIGH_PRIORITY
HOSTS
HOUR_MINUTE
HOUR_SECOND
INFILE
INSERT_ID
INT1
INT2
INT3
INT4
INT8
ISAM
KEYS
KILL
LAST_INSERT_ID
LENGTH
LINES
LOAD
LOGS
LONGBLOB
LONGTEXT
LOW_PRIORITY
MAX_ROWS
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT
MIN_ROWS
MINUTE_SECOND
MONTHNAME
MYISAM
OPTIONALLY
OUTFILE
PACK_KEYS
PASSWORD
PROCESS
PROCESSLIST
REGEXP
RELOAD
REPLACE
RLIKE
SHOW
SHUTDOWN
SONAME
SQL_BIG_RESULT
SQL_BIG_SELECTS
SQL_BIG_TABLES
SQL_LOG_OFF
SQL_LOG_UPDATE
SQL_LOW_PRIORITY_UPDATES
SQL_SELECT_LIMIT
SQL_SMALL_RESULT
SQL_WARNINGS
STARTING
STATUS
STRAIGHT_JOIN
STRING
TABLES
TERMINATED
TEXT
TINYBLOB
TINYINT
TINYTEXT
UNLOCK
UNSIGNED
USE
VARBINARY
VARIABLES
ZEROFILL
ACCESS
COMPRESS
INCREMENT
INITIAL
MAXEXTENTS
MINUS
MSLABEL
NOAUDIT
NOCOMPRESS
NOWAIT
NUMBER
OFFLINE
ONLINE
RAW
ROWID
ROWNUM
SUCCESSFUL
SYSDATE
UID
VALIDATE
VARCHAR2
ABORT
ANALYZE
BIT_LENGTH
CHAR_LENGTH
CHARACTER_LENGTH
COALESCE
CONVERT
COPY
CURRENT_SESSION
EXEC
EXTEND
EXTRACT
FOUND
LISTEN
LOWER
MOVE
NOTIFY
NULLIF
OCTET_LENGTH
OFFSET
OVERLAPS
SETOF
SQLCODE
SQLERROR
TRANSLATE
UNLISTEN
UPPER
VACUUM
VERBOSE
BACKUP
BREAK
BROWSE
BULK
CHECKPOINT
CLUSTERED
COMPUTE
CONTAINSTABLE
DBCC
DENY
DISK
DISTRIBUTED
DUMMY
DUMP
ERRLVL
FILLFACTOR
FREETEXT
FREETEXTTABLE
HOLDLOCK
IDENTITY_INSERT
IDENTITYCOL
LINENO
NOCHECK
NONCLUSTERED
OFFSETS
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
PERCENT
PRINT
PROC
RAISERROR
READTEXT
RECONFIGURE
REPLICATION
RESTORE
ROWCOUNT
ROWGUIDCOL
RULE
SAVE
SETUSER
TEXTSIZE
TOP
TRAN
TRUNCATE
TSEQUAL
UPDATETEXT
WAITFOR
WRITETEXT
ARITH_OVERFLOW
CHAR_ CONVERT
CONFIRM
CONTROLROW
DEFERRED
DISK DISTINCT
ENDTRAN
ERRORDATA
ERROREXIT
EXP_ROW_SIZE
FUNC
IDENTITY_GAP
IDENTITY_START
INSTALL
JAR
MAX_ROWS_PER_PAGE
MIRROR
MIRROREXIT
NOHOLDLOCK
NUMERIC_TRUNCATION
ONCE
OVER
PERM
PERMANENT
PROCESSEXIT
PROXY_TABLE
QUIESCE
READPAST
REFERENCES REMOVE
REORG
RESERVEPAGEGAP
SHARED
SPACE
STRINGSIZE
STRIPE
SYB_IDENTITY
SYB_RESTREE
SYB_TERMINATE
TEMP
UNPARTITION
USER_OPTION