O'Reilly logo

SQL in a Nutshell, 3rd Edition 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. Shared and Platform-Specific Keywords

The following tables display the keywords in the ANSI standard, and in the four 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

  • MySQL keywords

  • Oracle keywords

  • PostgreSQL keywords

  • SQL Server keywords

Table A-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 A-2. SQL2003 keywords

ABSOLUTE

ACTION

ADD

ADMIN

AFTER

AGGREGATE

ALIAS

ALL

ALLOCATE

ALTER

AND

ANY

ARE

ARRAY

AS

ASC

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

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