O'Reilly logo

SQL in a Nutshell by Kevin Kline

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. SQL99 and Vendor-Specific Keywords

The tables below display the keywords in the SQL99 standard and in the four vendor implementations of SQL that are discussed in this book. SQL keywords are described in more detail in Chapter 2.

Table A-1. SQL Keywords

ABSOLUTE

ACTION

ADD

ADMIN

AFTER

AGGREGATE

ALIAS

ALL

ALLOCATE

ALTER

AND

ANY

ARE

ARRAY

AS

ASC

ASSERTION

AT

AUTHORIZATION

BEFORE

BEGIN

BINARY

BIT

BLOB

BOOLEAN

BOTH

BREADTH

BY

CALL

CASCADE

CASCADED

CASE

CAST

CATALOG

CHAR

CHARACTER

CHECK

CLASS

CLOB

CLOSE

COLLATE

COLLATION

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

DIAGNOSTICS

DICTIONARY

DISCONNECT

DO

DOMAIN

DOUBLE

DROP

END-EXEC

EQUALS

ESCAPE

EXCEPT

EXCEPTION

EXECUTE

EXIT

EXPAND

EXPANDING

FALSE

FIRST

FLOAT

FOR

FOREIGN

FREE

FROM

FUNCTION

GENERAL

GET

GLOBAL

GOTO

GROUP

GROUPING

HANDLER

HASH

HOUR

IDENTITY

IF

IGNORE

IMMEDIATE

IN

INDICATOR

INITIALIZE

INITIALLY

INNER

INOUT

INPUT

INSERT

INT

INTEGER

INTERSECT

INTERVAL

INTO

IS

ISOLATION

ITERATE

JOIN

KEY

LANGUAGE

LARGE

LAST

LATERAL

LEADING

LEAVE

LEFT

LESS

LEVEL

LIKE

LIMIT

LOCAL

LOCALTIME ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required