SQL in a Nutshell, 2nd Edition

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:

• Shared keywords

• SQL2003 keywords

• DB2 keywords

• MySQL keywords

• Oracle keywords

• PostgreSQL keywords

• SQL Server keywords

• Sybase Adaptive Server keywords

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