VISUAL QUICKSTART GUIDE SQL Second Edition [Electronic resources] نسخه متنی

Appendix B. SQL Keywords

The appendix lists the SQL:2003 standard's reserved and non-reserved keywords. For information about keywords, see "SQL Syntax" and "Identifiers" in Chapter 3. DBMSes have their own nonstandard keywords; search your DBMS documentation for

keywords or

reserved words.

A

A

ABS

ABSOLUTE

ACTION

ADA

ADD

ADMIN

AFTER

ALL

ALLOCATE

ALTER

ALWAYS

AND

ANY

ARE

ARRAY

AS

ASC

ASENSITIVE

ASSERTION

ASSIGNMENT

ASYMMETRIC

AT

ATOMIC

ATTRIBUTE

ATTRIBUTES

AUTHORIZATION

AVG

B

BEFORE

BEGIN

BERNOULLI

BETWEEN

BIGINT

BINARY

BLOB

BOOLEAN

BOTH

BREADTH

BY

C

C

CALL

CALLED

CARDINALITY

CASCADE

CASCADED

CASE

CAST

CATALOG

CATALOG_NAME

CEIL

CEILING

CHAIN

CHAR

CHARACTER

CHARACTERISTICS

CHARACTERS

CHARACTER_LENGTH

CHARACTER_SET_CATALOG

CHARACTER_SET_NAME

CHARACTER_SET_SCHEMA

CHAR_LENGTH

CHECK

CLASS_ORIGIN

CLOB

CLOSE

COALESCE

COBOL

COLLATE

COLLATION

COLLATION_CATALOG

COLLATION_NAME

COLLATION_SCHEMA

COLLECT

COLUMN

COLUMN_NAME

COMMAND_FUNCTION

COMMAND_FUNCTION_CODE

COMMIT

COMMITTED

CONDITION

CONDITION_NUMBER

CONNECT

CONNECTION

CONNECTION_NAME

CONSTRAINT

CONSTRAINTS

CONSTRAINT_CATALOG

CONSTRAINT_NAME

CONSTRAINT_SCHEMA

CONSTRUCTOR

CONTAINS

CONTINUE

CONVERT

CORR

CORRESPONDING

COUNT

COVAR_POP

COVAR_SAMP

CREATE

CROSS

CUBE

CUME_DIST

CURRENT

CURRENT_DATE

CURRENT_DEFAULT_TRANSFORM_GROUP

CURRENT_PATH

CURRENT_ROLE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_TRANSFORM_GROUP_FOR_TYPE

CURRENT_USER

CURSOR

CURSOR_NAME

CYCLE

D

DATA

DATE

DATETIME_INTERVAL_CODE

DATETIME_INTERVAL_PRECISION

DAY

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFAULT

DEFAULTS

DEFERRABLE

DEFERRED

DEFINED

DEFINER

DEGREE

DELETE

DENSE_RANK

DEPTH

DEREF

DERIVED

DESC

DESCRIBE

DESCRIPTOR

DETERMINISTIC

DIAGNOSTICS

DISCONNECT

DISPATCH

DISTINCT

DOMAIN

DOUBLE

DROP

DYNAMIC

DYNAMIC_FUNCTION

DYNAMIC_FUNCTION_CODE

E

EACH

ELEMENT

ELSE

END

END-EXEC

EQUALS

ESCAPE

EVERY

EXCEPT

EXCEPTION

EXCLUDE

EXCLUDING

EXEC

EXECUTE

EXISTS

EXP

EXTERNAL

EXTRACT

F

FALSE

FETCH

FILTER

FINAL

FIRST

FLOAT

FLOOR

FOLLOWING

FOR

FOREIGN

FORTRAN

FOUND

FREE

FROM

FULL

FUNCTION

FUSION

G

G

GENERAL

GENERATED

GET

GLOBAL

GO

GOTO

GRANT

GRANTED

GROUP

GROUPING

H

HAVING

HIERARCHY

HOLD

HOUR

I

IDENTITY

IMMEDIATE

IMPLEMENTATION

IN

INCLUDING

INCREMENT

INDICATOR

INITIALLY

INNER

INOUT

INPUT

INSENSITIVE

INSERT

INSTANCE

INSTANTIABLE

INT

INTEGER

INTERSECT

INTERSECTION

INTERVAL

INTO

INVOKER

IS

ISOLATION

J

JOIN

K

K

KEY

KEY_MEMBER

KEY_TYPE

L

LANGUAGE

LARGE

LAST

LATERAL

LEADING

LEFT

LENGTH

LEVEL

LIKE

LN

LOCAL

LOCALTIME

LOCALTIMESTAMP

LOCATOR

LOWER

M

M

MAP

MATCH

MATCHED

MAX

MAXVALUE

MEMBER

MERGE

MESSAGE_LENGTH

MESSAGE_OCTET_LENGTH

MESSAGE_TEXT

METHOD

MIN

MINUTE

MINVALUE

MOD

MODIFIES

MODULE

MONTH

MORE

MULTISET

MUMPS

N

NAME

NAMES

NATIONAL

NATURAL

NCHAR

NCLOB

NESTING

NEW

NEXT

NO

NONE

NORMALIZE

NORMALIZED

NOT

NULL

NULLABLE

NULLIF

NULLS

NUMBER

NUMERIC

O

OBJECT

OCTETS

OCTET_LENGTH

OF

OLD

ON

ONLY

OPEN

OPTION

OPTIONS

OR

ORDER

ORDERING

ORDINALITY

OTHERS

OUT

OUTER

OUTPUT

OVER

OVERLAPS

OVERLAY

OVERRIDING

P

PAD

PARAMETER

PARAMETER_MODE

PARAMETER_NAME

PARAMETER_ORDINAL_POSITION

PARAMETER_SPECIFIC_CATALOG

PARAMETER_SPECIFIC_NAME

PARAMETER_SPECIFIC_SCHEMA

PARTIAL

PARTITION

PASCAL

PATH

PERCENTILE_CONT

PERCENTILE_DISC

PERCENT_RANK

PLACING

PLI

POSITION

POWER

PRECEDING

PRECISION

PREPARE

PRESERVE

PRIMARY

PRIOR

PRIVILEGES

PROCEDURE

PUBLIC

R

RANGE

RANK

READ

READS

REAL

RECURSIVE

REF

REFERENCES

REFERENCING

REGR_AVGX

REGR_AVGY

REGR_COUNT

REGR_INTERCEPT

REGR_R2

REGR_SLOPE

REGR_SXX

REGR_SXY

REGR_SYY

RELATIVE

RELEASE

REPEATABLE

RESTART

RESTRICT

RESULT

RETURN

RETURNED_CARDINALITY

RETURNED_LENGTH

RETURNED_OCTET_LENGTH

RETURNED_SQLSTATE

RETURNS

REVOKE

RIGHT

ROLE

ROLLBACK

ROLLUP

ROUTINE

ROUTINE_CATALOG

ROUTINE_NAME

ROUTINE_SCHEMA

ROW

ROWS

ROW_COUNT

ROW_NUMBER

S

SAVEPOINT

SCALE

SCHEMA

SCHEMA_NAME

SCOPE

SCOPE_CATALOG

SCOPE_NAME

SCOPE_SCHEMA

SCROLL

SEARCH

SECOND

SECTION

SECURITY

SELECT

SELF

SENSITIVE

SEQUENCE

SERIALIZABLE

SERVER_NAME

SESSION

SESSION_USER

SET

SETS

SIMILAR

SIMPLE

SIZE

SMALLINT

SOME

SOURCE

SPACE

SPECIFIC

SPECIFICTYPE

SPECIFIC_NAME

SQL

SQLEXCEPTION

SQLSTATE

SQLWARNING

SQRT

START

STATE

STATEMENT

STATIC

STDDEV_POP

STDDEV_SAMP

STRUCTURE

STYLE

SUBCLASS_ORIGIN

SUBMULTISET

SUBSTRING

SUM

SYMMETRIC

SYSTEM

SYSTEM_USER

T

TABLE

TABLESAMPLE

TABLE_NAME

TEMPORARY

THEN

TIES

TIME

TIMESTAMP

TIMEZONE_HOUR

TIMEZONE_MINUTE

TO

TOP_LEVEL_COUNT

TRAILING

TRANSACTION

TRANSACTIONS_COMMITTED

TRANSACTIONS_ROLLED_BACK

TRANSACTION_ACTIVE

TRANSFORM

TRANSFORMS

TRANSLATE

TRANSLATION

TREAT

TRIGGER

TRIGGER_CATALOG

TRIGGER_NAME

TRIGGER_SCHEMA

TRIM

TRUE

TYPE

U

UESCAPE

UNBOUNDED

UNCOMMITTED

UNDER

UNION

UNIQUE

UNKNOWN

UNNAMED

UNNEST

UPDATE

UPPER

USAGE

USER

USER_DEFINED_TYPE_CATALOG

USER_DEFINED_TYPE_CODE

USER_DEFINED_TYPE_NAME

USER_DEFINED_TYPE_SCHEMA

USING

V

VALUE

VALUES

VARCHAR

VARYING

VAR_POP

VAR_SAMP

VIEW

W

WHEN

WHENEVER

WHERE

WIDTH_BUCKET

WINDOW

WITH

WITHIN

WITHOUT

WORK

WRITE

Y

YEAR

Z

ZONE