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