SQL in a Nutshell

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 ...