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:
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 |
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 |
Get SQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.