SQL in a Nutshell (In a Nutshell (OReilly))

2017-07-07 02:10:07

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	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
LANGUAGE	LARGE	LAST	LATERAL
LEADING	LEAVE	LEFT	LESS
LEVEL	LIKE	LIMIT	LOCAL
LOCALTIME	LOCALTIMESTAMP	LOCATOR	LOOP
MATCH	MEMBER	MEETS	MERGE
MINUTE	MODIFIES	MODIFY	MODULE
MONTH	MULTISET	NAMES	NATIONAL
NATURAL	NCHAR	NCLOB	NEW
NEXT	NO	NONE	NORMALIZE
NOT	NULL	NUMERIC	OBJECT
OF	OFF	OLD	ON
ONLY	OPEN	OPERATION	OPTION
OR	ORDER	ORDINALITY	OUT
OUTER	OUTPUT	PAD	PARAMETER
PARAMETERS	PARTIAL	PATH	PERIOD
POSTFIX	PRECEDES	PRECISION	PREFIX
PREORDER	PREPARE	PRESERVE	PRIMARY
PRIOR	PRIVILEGES	PROCEDURE	PUBLIC
READ	READS	REAL	RECURSIVE
REDO	REF	REFERENCES	REFERENCING
RELATIVE	REPEAT	RESIGNAL	RESTRICT
RESULT	RETURN	RETURNS	REVOKE
RIGHT	ROLE	ROLLBACK	ROLLUP
ROUTINE	ROW	ROWS	SAVEPOINT
SCHEMA	SCROLL	SEARCH	SECOND
SECTION	SELECT	SEQUENCE	SESSION
SESSION_USER	SET	SETS	SIGNAL
SIZE	SMALLINT	SPECIFIC	SPECIFICTYPE
SQL	SQLEXCEPTION	SQLSTATE	SQLWARNING
START	STATE	STATIC	STRUCTURE
SUBMULTISET	SUCCEEDS	SUM	SYSTEM_USER
TABLE	TABLESAMPLE	TEMPORARY	TERMINATE
THAN	THEN	TIME	TIMESTAMP
TIMEZONE_HOUR	TIMEZONE_MINUTE	TO	TRAILING
TRANSACTION	TRANSLATION	TREAT	TRIGGER
TRUE	UESCAPE	UNDER	UNDO
UNION	UNIQUE	UNKNOWN	UNTIL
UPDATE	USAGE	USER	USING
VALUE	VALUES	VARCHAR	VARIABLE
VARYING	VIEW	WHEN	WHENEVER
WHERE	WHILE	WITH	WRITE
YEAR	ZONE

Table B-3. DB2 keywords

ACQUIRE	ADD	AFTER	ALIAS
ALL	ALLOCATE	ALLOW	ALTER
AND	ANY	AS	ASC
ASUTIME	AUDIT	AUTHORIZATION	AUXILIARY
AVG	BEFORE	BEGIN	BETWEEN
BINARY	BUFFERPOOL	BY	CALL
CALLED	CAPTURE	CASCADED	CASE
CAST	CCSID	CHAR	CHARACTER
CHECK	CLOSE	CLUSTER	COLLECTION
COLLID	COLUMN	COMMENT	COMMIT
CONCAT	CONDITION	CONNECT	CONNECTION
CONSTRAINT	CONTAINS	CONTINUE	COUNT
COUNT_BIG	CREATE	CROSS	CURRENT
CURRENT_DATE	CURRENT_LC_PATH	CURRENT_PATH	CURRENT_SERVER
CURRENT_TIME	CURRENT_TIMESTAMP	CURRENT_TIMEZONE	CURRENT_USER
CURSOR	DATA	DATABASE	DATE
DAY	DAYS	DB2GENERAL	DB2SQL
DBA	DBINFO	DBSPACE	DECLARE
DEFAULT	DELETE	DESC	DESCRIPTOR
DETERMINISTIC	DISALLOW	DISCONNECT	DISTINCT
DO	DOUBLE	DROP	DSSIZE
DYNAMIC	EDITPROC	ELSE	ELSEIF
END	END-EXEC	ERASE	ESCAPE
EXCEPT	EXCEPTION	EXCLUSIVE	EXECUTE
EXISTS	EXIT	EXPLAIN	EXTERNAL
FENCED	FETCH	FIELDPROC	FILE
FINAL	FOR	FOREIGN	FREE
FROM	FULL	FUNCTION	GENERAL
GENERATED	GO	GOTO	GRANT
GRAPHIC	GROUP	HANDLER	HAVING
HOUR	HOURS	IDENTIFIED	IF
IMMEDIATE	IN	INDEX	INDICATOR
INNER	INOUT	INSENSITIVE	INSERT
INTEGRITY	INTERSECT	INTO	IS
ISOBID	ISOLATION	JAVA	JOIN
KEY	LABEL	LANGUAGE	LC_CTYPE
LEAVE	LEFT	LIKE	LINKTYPE
LOCAL	LOCALE	LOCATOR	LOCATORS
LOCK	LOCKSIZE	LONG	LOOP
MAX	MICROSECOND	MICROSECONDS	MIN
MINUTE	MINUTES	MODE	MODIFIES
MONTH	MONTHS	NAME	NAMED
NHEADER	NO	NODENAME	NODENUMBER
NOT	NULL	NULLS	NUMPARTS
OBID	OF	ON	ONLY
OPEN	OPTIMIZATION	OPTIMIZE	OPTION
OR	ORDER	OUT	OUTER
PACKAGE	PAGE	PAGES	PARAMETER
PART	PARTITION	PATH	PCTFREE
PCTINDEX	PIECESIZE	PLAN	POSITION
PRECISION	PREPARE	PRIMARY	PRIQTY
PRIVATE	PRIVILEGES	PROCEDURE	PROGRAM
PSID	PUBLIC	QUERYNO	READ
READS	RECOVERY	REFERENCES	RELEASE
RENAME	REPEAT	RESET	RESOURCE
RESTRICT	RESULT	RETURN	RETURNS
REVOKE	RIGHT	ROLLBACK	ROW
ROWS	RRN	RUN	SCHEDULE
SCHEMA	SCRATCHPAD	SECOND	SECONDS
SECQTY	SECURITY	SELECT	SET
SHARE	SIMPLE	SOME	SOURCE
SPECIFIC	SQL	STANDARD	STATIC
STATISTICS	STAY	STOGROUP	STORES
STORPOOL	STYLE	SUBPAGES	SUBSTRING
SUM	SYNONYM	TABLE	TABLESPACE
THEN	TO	TRANSACTION	TRIGGER
TRIM	TYPE	UNDO	UNION
UNIQUE	UNTIL	UPDATE	USAGE
USER	USING	VALIDPROC	VALUES
VARIABLE	VARIANT	VCAT	VIEW
VOLUMES	WHEN	WHERE	WHILE
WITH	WLM	WORK	WRITE
YEAR	YEARS

Table B-4. MySQL keywords

ACTION	ADD	AFTER	AGGREGATE
ALL	ALTER	AND	AS
ASC	AUTO_INCREMENT	AVG	AVG_ROW_LENGTH
BETWEEN	BIGINT	BINARY	BIT
BLOB	BOOL	BOTH	BY
CASCADE	CASE	CHANGE	CHAR
CHARACTER	CHECK	CHECKSUM	COLUMN
COLUMNS	COMMENT	CONSTRAINT	CREATE
CROSS	CURRENT_DATE	CURRENT_TIME	CURRENT_TIMESTAMP
DATA	DATABASE	DATABASES	DATE
DATETIME	DAY	DAY_HOUR	DAY_MINUTE
DAY_SECOND	DAYOFMONTH	DAYOFWEEK	DAYOFYEAR
DEC	DECIMAL	DEFAULT	DELAY_KEY_WRITE
DELAYED	DELETE	DESC	DESCRIBE
DISTINCT	DISTINCTROW	DOUBLE	DROP
ELSE	ENCLOSED	END	ENUM
ESCAPE	ESCAPED	EXISTS	EXPLAIN
FIELDS	FILE	FIRST	FLOAT
FLOAT4	FLOAT8	FLUSH	FOR
FOREIGN	FROM	FULL	FUNCTION
GLOBAL	GRANT	GRANTS	GROUP
HAVING	HEAP	HIGH_PRIORITY	HOSTS
HOUR	HOUR_MINUTE	HOUR_SECOND	IDENTIFIED
IF	IGNORE	IN	INDEX
INFILE	INNER	INSERT	INSERT_ID
INT	INT1	INT2	INT3
INT4	INT8	INTEGER	INTERVAL
INTO	IS	ISAM	JOIN
KEY	KEYS	KILL	LAST_INSERT_ID
LEADING	LEFT	LENGTH	LIKE
LIMIT	LINES	LOAD	LOCAL
LOCK	LOGS	LONG	LONGBLOB
LONGTEXT	LOW_PRIORITY	MATCH	MAX
MAX_ROWS	MEDIUMBLOB	MEDIUMINT	MEDIUMTEXT
MIDDLEINT	MIN_ROWS	MINUTE	MINUTE_SECOND
MODIFY	MONTH	MONTHNAME	MYISAM
NATURAL	NO	NOT	NULL
NUMERIC	ON	OPTIMIZE	OPTION
OPTIONALLY	OR	ORDER	OUTER
OUTFILE	PACK_KEYS	PARTIAL	PASSWORD
PRECISION	PRIMARY	PRIVILEGES	PROCEDURE
PROCESS	PROCESSLIST	READ	REAL
REFERENCES	REGEXP	RELOAD	RENAME
REPLACE	RESTRICT	RETURNS	REVOKE
RLIKE	ROW	ROWS	SECOND
SELECT	SET	SHOW	SHUTDOWN
SMALLINT	SONAME	SQL_BIG_RESULT	SQL_BIG_SELECTS
SQL_BIG_TABLES	SQL_LOG_OFF	SQL_LOG_UPDATE	SQL_LOW_PRIORITY_UPDATES
SQL_SELECT_LIMIT	SQL_SMALL_RESULT	SQL_WARNINGS	STARTING
STATUS	STRAIGHT_JOIN	STRING	TABLE
TABLES	TEMPORARY	TERMINATED	TEXT
THEN	TIME	TIMESTAMP	TINYBLOB
TINYINT	TINYTEXT	TO	TRAILING
TYPE	UNIQUE	UNLOCK	UNSIGNED
UPDATE	USAGE	USE	USING
VALUES	VARBINARY	VARCHAR	VARIABLES
VARYING	WHEN	WITH	WRITE
ZEROFILL

Table B-5. Oracle keywords

ACCESS	ADD	ALL	ALTER
AND	ANY	AS	ASC
AUDIT	BETWEEN	BY	CHAR
CHECK	CLUSTER	COLUMN	COMMENT
COMPRESS	CONNECT	CREATE	CURRENT
DATE	DECIMAL	DEFAULT	DELETE
DESC	DISTINCT	DROP	ELSE
EXCLUSIVE	EXISTS	FILE	FLOAT
FOR	FROM	GRANT	GROUP
HAVING	IDENTIFIED	IMMEDIATE	IN
INCREMENT	INDEX	INITIAL	INSERT
INTEGER	INTERSECT	INTO	IS
LEVEL	LIKE	LOCK	LONG
MAXEXTENTS	MINUS	MODE	MODIFY
MSLABEL	NOAUDIT	NOCOMPRESS	NOT
NOWAIT	NULL	NUMBER	OF
OFFLINE	ON	ONLINE	OPTION
OR	ORDER	PCTFREE	PRIOR
PRIVILEGES	PUBLIC	RAW	RENAME
RESOURCE	REVOKE	ROW	ROWID
ROWNUM	ROWS	SELECT	SESSION
SET	SHARE	SIZE	SMALLINT
START	SUCCESSFUL	SYNONYM	SYSDATE
TABLE	THEN	TO	TRIGGER
UID	UNION	UNIQUE	UPDATE
USER	VALIDATE	VALUES	VARCHAR
VARCHAR2	VIEW	WHENEVER	WHERE
WITH

Table B-6. PostgreSQL keywords

ABORT	ADD	ALL	ALLOCATE
ALTER	ANALYZE	AND	ANY
ARE	AS	ASC	ASSERTION
AT	AUTHORIZATION	AVG	BEGIN
BETWEEN	BINARY	BIT	BIT_LENGTH
BOTH	BY	CASCADE	CASCADED
CASE	CAST	CATALOG	CHAR
CHAR_LENGTH	CHARACTER	CHARACTER_LENGTH	CHECK
CLOSE	CLUSTER	COALESCE	COLLATE
COLLATION	COLUMN	COMMIT	CONNECT
CONNECTION	CONSTRAINT	CONTINUE	CONVERT
COPY	CORRESPONDING	COUNT	CREATE
CROSS	CURRENT	CURRENT_DATE	CURRENT_SESSION
CURRENT_TIME	CURRENT_TIMESTAMP	CURRENT_USER	CURSOR
DATE	DEALLOCATE	DEC	DECIMAL
DECLARE	DEFAULT	DELETE	DESC
DESCRIBE	DESCRIPTOR	DIAGNOSTICS	DISCONNECT
DISTINCT	DO	DOMAIN	DROP
ELSE	END	ESCAPE	EXCEPT
EXCEPTION	EXEC	EXECUTE	EXISTS
EXISTS	EXPLAIN	EXTEND	EXTERNAL
EXTRACT	FALSE	FETCH	FIRST
FLOAT	FOR	FOREIGN	FOUND
FROM	FULL	FULL	GET
GLOBAL	GO	GOTO	GRANT
GROUP	HAVING	IDENTITY	IN
INDICATOR	INNER	INPUT	INSERT
INTERSECT	INTERVAL	INTO	IS
JOIN	LAST	LEADING	LEFT
LIKE	LISTEN	LOAD	LOCAL
LOCK	LOWER	MAX	MIN
MODULE	MOVE	NAMES	NATIONAL
NATURAL	NCHAR	NEW	NO
NONE	NOT	NOTIFY	NULL
NULLIF	NUMERIC	OCTET_LENGTH	OFFSET
ON	OPEN	OR	ORDER
OUTER	OUTPUT	OVERLAPS	PARTIAL
POSITION	PRECISION	PREPARE	PRESERVE
PRIMARY	PRIVILEGES	PROCEDURE	PUBLIC
REFERENCES	RESET	REVOKE	RIGHT
ROLLBACK	ROWS	SCHEMA	SECTION
SELECT	SESSION	SESSION_USER	SET
SETOF	SHOW	SIZE	SOME
SQL	SQLCODE	SQLERROR	SQLSTATE
SUBSTRING	SUM	SYSTEM_USER	TABLE
TEMPORARY	THEN	TO	TO
TRAILING	TRANSACTION	TRANSLATE	TRANSLATION
TRIM	TRUE	UNION	UNIQUE
UNIQUE	UNKNOWN	UNLISTEN	UNTIL
UPDATE	UPPER	USAGE	USER
USING	VACUUM	VALUE	VALUES
VARCHAR	VARYING	VERBOSE	VIEW
WHEN	WHENEVER	WHERE	WITH
WORK	WRITE

Table B-7. Microsoft SQL Server keywords

ADD	ALL	ALTER	AND
ANY	AS	ASC	AUTHORIZATION
BACKUP	BEGIN	BETWEEN	BREAK
BROWSE	BULK	BY	CASCADE
CASE	CHECK	CHECKPOINT	CLOSE
CLUSTERED	COALESCE	COLLATE	COLUMN
COMMIT	COMPUTE	CONSTRAINT	CONTAINS
CONTAINSTABLE	CONTINUE	CONVERT	CREATE
CROSS	CURRENT	CURRENT_DATE	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_USER	CURSOR	DATABASE
DBCC	DEALLOCATE	DECLARE	DEFAULT
DELETE	DENY	DESC	DISK
DISTINCT	DISTRIBUTED	DOUBLE	DROP
DUMMY	DUMP	ELSE	END
ERRLVL	EXCEPT	EXEC	EXECUTE
EXISTS	EXIT	FETCH	FILE
FILLFACTOR	FOR	FOREIGN	FREETEXT
FREETEXTTABLE	FROM	FULL	FUNCTION
GOTO	GRANT	GROUP	HAVING
HOLDLOCK	IDENTITY	IDENTITY_INSERT	IDENTITYCOL
IF	IN	INDEX	INNER
INSERT	INTERSECT	INTO	IS
JOIN	KEY	KILL	LEFT
LIKE	LINENO	LOAD	NATIONAL
NOCHECK	NONCLUSTERED	NOT	NULL
NULLIF	OF	OFF	OFFSETS
ON	OPEN	OPENDATASOURCE	OPENQUERY
OPENROWSET	OPENXML	OPTION	OR
ORDER	OUTER	PERCENT	PLAN
PRECISION	PRIMARY	PRINT	PROC
PROCEDURE	PUBLIC	RAISERROR	READ
READTEXT	RECONFIGURE	REFERENCES	REPLICATION
RESTORE	RESTRICT	RETURN	REVOKE
RIGHT	ROLLBACK	ROWCOUNT	ROWGUIDCOL
RULE	SAVE	SCHEMA	SELECT
SESSION_USER	SET	SETUSER	SHUTDOWN
SOME	STATISTICS	SYSTEM_USER	TABLE
TEXTSIZE	THEN	TO	TOP
TRAN	TRANSACTION	TRIGGER	TRUNCATE
TSEQUAL	UNION	UNIQUE	UPDATE
UPDATETEXT	USE	USER	VALUES
VARYING	VIEW	WAITFOR	WHEN
WHERE	WHILE	WITH	WRITETEXT

Table B-8. Sybase Adaptive Server keywords

ABSOLUTE	ACTION	ADD	ALL
ALLOCATE	ALTER	AND	ANY
ARE	ARITH_OVERFLOW	AS	ASC
ASSERTION	AT	AUTHORIZATION	AVG
BEGIN	BETWEEN	BIT	BIT_LENGTH
BOTH	BREAK	BROWSE	BULK
BY	CASCADE	CASCADED	CASE
CAST	CATALOG	CHAR	CHAR_ CONVERT
CHAR_LENGTH	CHARACTER	CHARACTER_LENGTH	CHECK
CHECKPOINT	CLOSE	CLUSTERED	COALESCE
COLLATE	COLLATION	COLUMN	COMMIT
COMPUTE	CONFIRM	CONNECT	CONNECTION
CONSTRAINT	CONSTRAINTS	CONTINUE	CONTROLROW
CONVERT	CORRESPONDING	COUNT	CREATE
CROSS	CURRENT	CURRENT_DATE	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_USER	CURSOR	DATABASE
DATE	DAY	DBCC	DEALLOCATE
DEC	DECIMAL	DECLARE	DEFAULT
DEFERRABLE	DEFERRED	DELETE	DESC
DESCRIBE	DESCRIPTOR	DETERMINISTIC	DIAGNOSTICS
DISCONNECT	DISK DISTINCT	DOMAIN	DOUBLE
DROP	DUMMY	DUMP	ELSE
END	END-EXEC	ENDTRAN	ERRLVL
ERRORDATA	ERROREXIT	ESCAPE	EXCEPT
EXCEPTION	EXCLUSIVE	EXEC	EXECUTE
EXISTS	EXIT	EXP_ROW_SIZE	EXTERNAL
EXTRACT	FALSE	FETCH	FILLFACTOR
FIRST	FLOAT	FOR	FOREIGN
FOUND	FROM	FULL	FUNC
FUNCTION	GET	GLOBAL	GO
GOTO	GRANT	GROUP	HAVING
HOLDLOCK	HOUR	IDENTITY	IDENTITY_GAP
IDENTITY_INSERT	IDENTITY_START	IF	IMMEDIATE
IN	INDEX	INDICATOR	INITIALLY
INNER	INOUT	INPUT	INSENSITIVE
INSERT	INSTALL	INT	INTEGER
INTERSECT	INTERVAL	INTO	IS
ISOLATION	JAR	JOIN	KEY
KILL	LANGUAGE	LAST	LEADING
LEFT	LEVEL	LIKE	LINENO
LOAD	LOCAL	LOCK	LOWER
MATCH	MAX	MAX_ROWS_PER_PAGE	MIN
MINUTE	MIRROR	MIRROREXIT	MODIFY
MODULE	MONTH	NAMES	NATIONAL
NATURAL	NCHAR	NEW	NEXT
NO	NOHOLDLOCK	NONCLUSTERED	NOT
NULL	NULLIF	NUMERIC	NUMERIC_TRUNCATION
OCTET_LENGTH	OF	OFF	OFFSETS
ON	ONCE	ONLINE	ONLY
OPEN	OPTION	OR	ORDER
OUT	OUTER	OUTPUT	OVER
OVERLAPS	PAD	PARTIAL	PARTITION
PERM	PERMANENT	PLAN	POSITION
PRECISION	PREPARE	PRESERVE	PRIMARY
PRINT	PRIOR	PRIVILEGES	PROC
PROCEDURE	PROCESSEXIT	PROXY_TABLE	PUBLIC
QUIESCE	RAISERROR	READ	READPAST
READTEXT	REAL	RECONFIGURE	REFERENCES REMOVE
RELATIVE	REORG	REPLACE	REPLICATION
RESERVEPAGEGAP	RESTRICT	RETURN	RETURNS
REVOKE	RIGHT	ROLE	ROLLBACK
ROWCOUNT	ROWS	RULE	SAVE
SCHEMA	SCROLL	SECOND	SECTION
SELECT	SESSION_USER	SET	SETUSER
SHARED	SHUTDOWN	SIZE	SMALLINT
SOME	SPACE	SQL	SQLCODE
SQLERROR	SQLSTATE	STATISTICS	STRINGSIZE
STRIPE	SUBSTRING	SUM	SYB_IDENTITY
SYB_RESTREE	SYB_TERMINATE	SYSTEM_USER	TABLE
TEMP	TEMPORARY	TEXTSIZE	THEN
TIME	TIMESTAMP	TIMEZONE_HOUR	TIMEZONE_MINUTE
TO	TRAILING	TRAN	TRANSACTION
TRANSLATE	TRANSLATION	TRIGGER	TRIM
TRUE	TRUNCATE	TSEQUAL	UNION
UNIQUE	UNKNOWN	UNPARTITION	UPDATE
UPPER	USAGE	USE	USER
USER_OPTION	USING	VALUE	VALUES
VARCHAR	VARYING	VIEW	WAITFOR
WHEN	WHENEVER	WHERE	WHILE
WITH	WORK	WRITE	WRITETEXT
YEAR	ZONE