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

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.