SQL in a Nutshell, 3rd Edition

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