SQL Glossary
From
SQL-99 COMPLETE, REALLY
by Peter Gulutzan and Trudy Pelzer.
!
!=
#
$
"
%
&
'
(
)
*
+
,
-
.
...
/
/*
:
;
<
<=
<>
=
>
>=
?
@
ABANDONED
ABS
ABSOLUTE
ABSTRACT
ABSTRACT DATA TYPE
ACCENTED LETTER
ACCESS
ACCESS ERROR
ACCESS MODE
ACCESS PLAN
ACCESS PRIVILEGE
ACCESS RULE
ACCURATE
ACID
ACMO
ACTION
ACTION QUERY
ACTIVATED
ACTIVE
ACTIVE CONDITION
ACTIVE RULE
ADMIN
ADT
AFNOR
AGENT
AGGREGATE FUNCTION
AGGREGATTION
AGGREGATION RULE
AGREE
ALGORITHM
ALIAS
ALL
ALL PRIVILEGES
ALLOCATE
ALLOCATED SQL-CONNECTION
ALLOCATED SQL-ENVIRONMENT
ALLOCATED SQL STATEMENT
ALPHABET
ALTER
ALTERNATE KEY
AMERICAN NATIONAL
AMERICAN STANDARD CODE
ANNEX
ANSI
ANY
APD
API
APPLICABLE PRIVILEGE
APPLICATION
APPLICATION DESC
APPLICATION PARAMETER
APPLICATION ROW
APPROXIMATE NUMERIC
ARGUMENT
ARITHMETIC
ARRAY
ARD
ASCENDING
ASCII
ASCII_FULL
ASCII_GRAPHIC
ASENSITIVE CURSOR
ASSERTION
ASSIGN
ASSIGNABLE
ASSIGNMENT STATEMENT
ASSOCIATE
ASSOCIATIVE
ASYNCHRONOUS
ATOMIC SUBQUERY
ATOMIC TRANSACTION
ATOMIC VALUE
ATTRIBUTE
AUGMENTED
AUTHORIZATION
AUTHORIZATION_IDENTIFIER
AUTOMATIC COMMIT
AUTOMATIC DESC
AVG
BACKUP
BACKUS-NAUR
BAG
BASE
BASE TABLE
BASIC PREDICATE
BASIC RESULT
BATCH
BETWEEN
BINARY
BINARY LARGE OBJECT
BINARY STRING
BIND
BINDING OFFSET
BINDING STYLE
BINDINGS
BIT
BIT STRING
BIT_LENGTH
BLOB
BLOCK
BLOCK CURSOR
BNF
BOOLEAN
BOUND COLUMN
BRACKETED COMMENT
BSI
BUFFER
BUILT-IN DATA TYPE
BUILT-IN FUNCTION
BYTE
C
C DATA TYPE
CALCULATED FIELD
CALL STATEMENT
CANDIDATE KEY
CANDIDATE ROW
CAPITAL LETTER
CARDINAL NUMBER
CARDINALITY
CARTESIAN
CASCADE
CASE
CASE SENSITIVE
CAST
CATALOG
CATALOG FUNCTION
CBEMA
CHAIN
CHAR
CHARACTER
CHARACTER LARGE OBJECT
CHARACTER REPERTOIRE
CHARACTER SET
CHARACTER STRING
CHECK CONSTRAINT
CHECK OPTION
CHECKPOINT
CLASS
CLASS ORIGIN
CLAUSE
CLI
CLID
CLIENT/SERVER
CLOB
CLOSE
CLOSURE
CLUSTER
COALESCE
COBOL
CODE PAGE
CODING
COERCIBILITY
COLLATION
COLLATING SEQUENCE
COLLECTION
COLUMN
COLUMN CONSTRAINT
COLUMN FUNCTION
COLUMN INTEGRITY RULE
COLUMN REFERENCE
COMMA LIST
COMMAND
COMMENT
COMMIT
COMMUTATIVE OPERATOR
COMP-OP
COMPARISON
COMPATIBLE
COMPILATION UNIT
COMPILE
COMPLETION CONDITION
COMPLEXITY
COMPONENT
COMPOSITE KEY
COMPOUND STATEMENT
CONCATENATION
CONCISE CODE
CONCISE FUNCTION
CONCURRENCY
CONDITION
CONDITION HANDLING
CONDITIONAL EXPRESSION
CONDITIONAL VALUE
CONDITION INFORMATION
CONFORMANCE LEVEL
CONNECTION
CONNECTION BROWSING
CONNECTION HANDLE
CONNECTION STATEMENT
CONSISTENCY
CONSTANT
CONSTRAINT
CONSTRAINT MODE
CONSTRUCTED TYPE
CONSTRUCTOR FUNCTION
CONTAINMENT
CONTROL DECLARATION
CONTROL STATEMENT
CONVERT
CORE ODBC
CORE SQL
CORRELATED SUBQUERY
CORRELATION NAME
CORRESPONDING
CORRIGENDUM
COUNT
CROSS JOIN
CURRENT
CURRENT ROW
CURRENT_USER
CURSOR
CYCLE
DARWEN, HUGH
DATA
DATA BANK
DATA CHANGE STATEMENT
DATA CONTROL LANGUAGE
DATA DEFINITION LANGUAGE
DATA DICTIONARY
DATA ELEMENT
DATA ENVIRONMENT
DATA EXCEPTION
DATA MANIPULATION
DATA MANIPULATION
DATA REPOSITORY
DATA SOURCE
DATA TYPE
DATA TYPE CODE
DATA TYPE SPECIFIER
DATA-AT-EXECUTION
DATABASE
DATABASE ENGINE
DATABASE MANAGEMENT
DATE
DATETIME
DATETIME_INTERVAL_CODE
DAY-TIME INTERVAL
DB2
DBA
DBASE
DBC
DBL
DBMS
DBMS-BASED DRIVER
DBSSG
DCL
DDL
DEADLOCK
DECIMAL
DECIMALDIGITS
DECLARATION
DECLARED TYPE
DECOMPOSE
DEFAULT
DEFERRABLE
DEFERRED
DEFERRED PARAMETER
DEFINE
DEFINITION_SCHEMA
DEGREE
DELETE
DELETE RULE
DELIMITED TEXT FILE
DELIMITED IDENTIFIER
DELIMITER TOKEN
DELPHI
DENORMALIZE
DEPRECATED
DEREFERENCE
DERIVED COLUMN
DERIVED TABLE
DESC
DESCENDING
DESCRIBE
DESCRIPTOR
DESCRIPTOR AREA
DESCRIPTOR INDEX
DESCRIPTOR RECORD
DESKTOP DATABASE
DETAIL
DETERMINISTIC
DIAGNOSTIC RECORD
DIAGNOSTIC AREA
DIAGNOSTICS AREA LIMIT
DIAGNOSTICS STATEMENT
DICTIONARY
DIFFERENCE
DIGIT
DIN
DIRECT
DIRECT SQL
DIRTY READ
DISCONNECT
DISJOINT
DISPLACEMENT
DISTINCT
DISTINCT PREDICATE
DISTINCT TYPE
DISTRIBUTIVE
DLL
DML
DOCUMENTATION_SCHEMA
DOMAIN
DORMANT
DOUBLE PRECISION
DOUBLE QUOTE
DRIVER
DRIVER MANAGER
DRIVER SETUP DLL
DROP
DUPLICATE
DURABILITY
DYADIC
DYNAMIC CONSTRAINT
DYNAMIC CURSOR
DYNAMIC PARAMETER
DYNAMIC PARAMETER
DYNAMIC PARAMETER
DYNAMIC SQL
DYNAMIC STATEMENT
DYNASET
EBCDIC
ELEMENT
ELEVATOR SEEK
EMBEDDED SQL
EMPTY SET
ENCAPSULATION
ENCODING
ENCOMPASSING
ENTITY
ENTRY
ENV
ENVIRONMENT
ENVIRONMENT ATTRIBUTE
ENVIRONMENT HANDLE
EQUAL
EQUIJOIN
EQUIVALENT
ERROR
ESCAPE
ESCAPE SEQUENCE
ESTABLISH
EVENT
EXACT NUMERIC
EXCEPT
EXCEPTION CONDITION
EXCEPTION STATEMENT
EXCLUSIVE
EXECUTE
EXISTS
EXPLAIN
EXPLICIT
EXPLICITLY-ALLOCATED
EXPONENT
EXPONENTIAL NOTATION
EXPORT
EXPRESSION
EXTENSION
EXTERNAL ROUTINE
EXTRACT
EXTREME FUNCTION
FALSE
FAMILY
FEATURE
FETCH
FETCH ORIENTATION
FETCH TARGET
FIELD
FILE
FILE SERVER
FILE-BASED DRIVER
FINAL
FIPS
FIRE
FIRST NORMAL FORM
FIXED-LENGTH ENCODING
FIXED-LENGTH STRING TYPE
FLAGGER
FLOAT
FOLD
FOR
FOREIGN KEY
FORM-OF-USE
FORMAT RULE
FORTRAN
FORWARD-ONLY CURSOR
FRACTIONAL PRECISION
FREE
FROM CLAUSE
FULL OUTER JOIN
FULL SQL
FULL-TABLE SCAN
FUNCTION
FUNCTIONAL DEPENDENCY
GATEWAY
GENERAL CONSTRAINT
GENERAL RULE
GET DESCRIPTOR
GET DIAGNOSTIC
GLOBAL
GLYPH
GMT
GRANT
GRANT OPTION
GRANTEE
GRANTOR
GRANULARITY
GRAPHIC
GRAPHIC_IRV
GREENWICH MEAN TIME
GROUP
GROUP BY CLAUSE
GROUP FUNCTION
GROUPED TABLE
GROUPED VIEW
GROUPING COLUMN
GULUTZAN, PETER
HANDLE
HANDLER
HASH
HAVING CLAUSE
HDBC
HDESC
HENV
HEXADECIMAL
HEXIT
HIERARCHICAL DATABASE
HIERARCHY
HOLDABLE CURSOR
HOST LANGUAGE
HOST VARIABLE
HSTMT
IBM
IDA
IDEMPOTENT LAW
IDENTIFIER
IDENTIFIER CHAIN
IDENTIFIER LENGTH
IDENTITY
IEC
IEF
IF STATEMENT
IMMEDIATE
IMPEDANCE MISMATCH
IMPLEMENTATION
IMPLEMENTATION DEFINED
IMPLEMENTATION
IMPLEMENTATION
IMPLEMENTATION
IMPLEMENTOR
IMPLICIT
IMPORT
IN
INCLUDE
INDEX
INDICATOR
INFORMATION_SCHEMA
INFORMIX
INGRES
INHERIT
INHERITANCE
INITIALLY
INLINE CONSTRAINT
INNER JOIN
INNER TABLE
INPRISE
INPUT
INSENSITIVE CURSOR
INSERT
INSTALLER DLL
INSTANCE
INSTANTIABLE
INTEGER
INTEGRITY
INTEGRITY CONSTRAINT
INTEGRITY ENHANCEMENT
INTERACTIVE SQL
INTERFACE
INTERMEDIATE SQL
INTERNATIONAL
INTERNATIONALIZATION
INTEROPERABILITY
INTERSECT
INTERVAL
INTERVAL LEADING
INTERVAL QUALIFIER
INTRODUCER
INVALID
INVOCATION
IPD
IRD
IS
ISO
ISO 8859-X
ISO 9075, ISO 92, ETC
ISO COMMITTEE
ISO STANDARD CHARACTER
ISO STANDARD DATE
ISO STANDARD SQL
ISO/IEC JTC1/SC22 WG15
ISOLATION
ITEM
ITEM DESCRIPTOR AREA
ITEM FIELD
ITEM QUALIFIER
ITEM REFERENCE
ITERATE
JAVA
JDBC
JOB
JOIN
JOURNAL
JSQL
JULIAN
KB
KEY
KEY WORD
KEYSET
KEYWORD
LANGUAGE
LATIN ALPHABET
LATIN LETTER
LATIN1
LEADING
LEAF
LEAVE
LEFT JOIN
LENGTH
LETTER
LEVEL
LIKE
LIST
LITERAL
LOB
LOCATOR
LOCK
LOG
LOGIC
LOGICAL OPERATOR
LOGIN
LONG DATA
LOOP
LOWER
LOWER CASE
MACHINE DATA SOURCE
MACRO
MANIPULATE
MANTISSA
MANUAL COMMIT
MATCH
MATCHLIST
MATERIALIZED VIEW
MATRIX
MAX
MAXIMAL
MB
MEMBER
MERGED COLUMN
MESSAGE
METADATA
METHOD
MIDDLEWARE
MIN
MINIMAL COMMON
MOD
MODIFY
MODULE
MODULE LANGUAGE
MODULO
MOS SPECIFIC TYPE
MONADIC
MULTI-VALUE KEY
MULTIBYTE
MULTICOLUMN
MULTIMEDIA
MULTIPLE-TIER DRIVER
MULTISET
MUMPS
MUTATOR FUNCTION
MUTUALLY ASSIGNABLE
MUTUALLY COMPARABLE
NAME
NAME CLASS
NAMESPACE
NATIONAL CHARACTER
NATIVE ERROR
NATURAL NUMBER
NCHAR
NCITS
NCLOB
NEST
NESTED TABLE
NETWORK DATABASE
NEWLINE
NILADIC
NIST
NO-DATA CONDITION
NODE
NON-DETERMINISTIC
NORMALIZATION
NORMALIZE
NORMATIVE REFERENCE
NOT NULL
NULL
NULL COLLATION
NULL POINTER
NULL TERMINATION
NULL VALUE
NULL-CALL ROUTINE
NULLABLE
NULLIF
NUMBER
NUMERIC
O/R
OBJECT
OBJECT CLASS
OBVJECT CODE
OBJECT IDENTIFIER
OBJECT IDENTIFIER
OBJECT/RELATIONAL
OBSERVER FUNCTION
OCCURRENCE
OCTET
OCTET_LENGTH
ODBC
ODBC ADMINISTRATOR
ODBC DRIVER
ODBC DRIVER MANAGER
ODBC SDK
ODMG
OLAP
OLTP
OLD VALUE
OO
OPERAND
OPERATING SYSTEM
OPERATION
OPERATOR
OPTIMISTIC CONCURRENCY
OPTIMIZE
OQL
ORACLE
ORDER BY CLAUSE
ORDERED PAIR
ORIENTATION
ORTHOGONAL
OS COMMIT
OUTER JOIN
OUTER REFERENCE
OUTER UNION
OUTPUT
OVERFLOW
OVERLAPS
OVERLAY
OVERLOAD
OWNER
PACKAGE
PAD CHARACTER
PAGE
PARAMETER
PARAMETER DESCRIPTOR
PARAMETER ARRAY
PARAMETER MARKER
PARENT_KEY
PARSER
PARTIAL
PASCAL
PASSIVE VALUE
PATH
PATTERN
PD
PENDING RESULTS
PERMANENT TABLE
PERMISSION
PERSISTENT
PERSISTENT BASE TABLE
PERSISTENT STORED
PERSISTENT TABLE
PESSIMISTIC CONCURRENCY
PHANTOM
PHYSICAL
PL/I
POINTER
POLYMORPHISM
PORTABLE
POSITION
POSITIONED OPERATOR
PRECEDENCE RULES
PRECISION
PRECOMPILER
PREDEFINED DATA TYPE
PREDICATE
PREFERRED CANDIDATE
PREFIX
PREPARABLE STATEMENT
PREPARE
PREPROCESSOR
PRIMARY DATETIME FIELD
PRIMARY KEY
PRIME
PRIME TABLE
PRIMITIVE DATA TYPE
PRIOR
PRIVILEGE
PROCEDURE
PROCEDURE COLUMN
PROCEDURE STATEMENT
PROGRESS
PROJECTION
PROPER
PROPERTY
PROPRIETARY
PROTOTYPE
PSEUDO-COLUMN
PSM
PUBLIC
QUALIFIER
QUANTIFIED
QUANTIFIER
QUERY
QUERY EXPRESSION
QUERY OPERATOR
QUERY SPECIFICATION
QUOTE
QUOTED IDENTIFIER
RADIX
RANGE
RAW
RD
RDA
RDB
READ
READ-ONLY
REAL
RECLAIM
RECORD
RECURSIVE
RECURSIVE UNION
REDUNDANT
REFERENCE
REFERENCEABLE TABLE
REFERENCED TABLE
REFERENCES
REFERENCING TABLE
REFERENTIAL ACTION
REFERENTIAL CYCLE
REFERENTIAL INTEGRITY
REGULAR IDENTIFIER
RELATION
RELATIONAL DATABASE
RELATIONAL DATABASE
RELATIONAL OPERATOR
RELATIONAL THEORY
RELATIVE
REMOTE DATABASE ACCESS
REPEAT
REPEATABLE READ
REPEATING SUBQUERY
REPERTOIRE
REPLICATE
REPOSITORY
REPRESENTATION
REQUEST
REQUIREMENT
RESERVED WORD
RESET
RESIGNAL
RESOURCE
RESTRICT
RESULT
RESULT CODE
RESULT SET
RESULT-GENERATING
RETRIEVAL ASSIGNMENT
RETRIEVE
RETURN CODE
RETURNED OCTET LENGTH
REVOKE
RIGHT JOIN
ROLE
ROLL FORWARD
ROLLBACK
ROUNDING
ROUTINE
ROUTINE NAME
ROW
ROW CONSTRUCTOR
ROW DESCRIPTOR
ROW IDENTIFIER
ROW NUMBER
ROW STATUS ARRAY
ROW SUBQUERY
ROW TYPE
ROW VALUE CONSTRUCTOR
ROWID
ROWSET
ROWSET BUFFER
RULE
RUNTIME
SAG
SATISFY
SAVEPOINT
SCALAR FUNCTION
SCALAR OPERATOR
SCALAR SUBQUERY
SCALAR VALUE
SCALE
SCHEMA
SCHEMA DEFINITION
SCHEMA MANIPULATION
SCHEMA MANIPULATION
SCHEMA STATEMENT
SCIENTIFIC NOTATION
SCOPE
SCROLL CURSOR
SEARCH CONDITION
SEARCHED OPERATION
SECOND NORMAL FORM
SECURITY
SELECT CLAUSE
SELECT EXPRESSION
SELECT LIST
SELF JOIN
SELF-REFERENCING
SEMIRELATIONAL
SEPARATOR
SEQUEL
SEQUENCE
WSEQUENTIAL
SERIALIZABLE
SERIES
SERVER
SESSION
SESSION STATEMENT
SESSION_USER
SET
SET CONDITION
SET FUNCTION
SET OPERATOR
SET QUANTIFIER
SET STATEMENT
SET THEORY
SHAPE
SIGNAL
SIGNATURE
SIGNED NUMBER
SIGNIFICANT
SIMILAR
SIMPLE COMMENT
SIMPLE KEY
SIMPLE LATIN LETTER
SIMPLE TABLE
SIMPLE TARGET
SIMPLE VALUE
SINGLE QUOTE
SINGLETON SELECT
SITE
SKELETON
SMALL LETTER
SMALLINT
SOME
SORT
SOURCE
SOURCE CODE
SPACE
SPARC
SPECIAL CHARACTER
SPECIAL VALUE
SPECIFIC
SPECIFIC NAME
SPECIFICATION
SQL
SQL CONFORMANCE LEVEL
SQL DATA TYPE
SQL DATA TYPE CODE
SQL LANGUAGE CHARACTER
SQL PROCEDURE
SQL ROUTINE
SQL SERVER
SQL STATEMENT
SQL STATEMENT IDENTIFIER
SQL TRANSACTION
SQL-
SQL-89
SQL-92
SQL-CONNECTION
SQL-CONTROL STATEMENT
SQL-DATA
SQL-DATA STATEMENT
SQL-PATH
SQL-SCHEMA STATEMENT
SQL-SERVER MODULE
SQL-SESSION STATEMENT
SQL-TRANSACTION
SQL2
SQL3
SQL4
SQLCA
SQLCLI.H
SQLCODE
SQLDA
SQLJ
SQLSTATE
SQL_CHARACTER
SQL_TEXT
STANDARD
STATE
STATEMENT
STATEMENT HANDLE
STATEMENT IDENTIFIER
STATEMENT INFORMATION
STATEMENT TERMINATOR
STATIC CURSOR
STATIC SQL
STATUS CODE
STATUS CONDITION
STATUS PARAMETER
STATUS RECORD
STATUS VARIABLES
STMT
STORE
STORE ASSIGNMENT
STORED PROCEDURE
STRING
STRUCTURE
STRUCTURED TYPE
SUB
SUBCODE
SUBCLASS
SUBJECT DATA TYPE
SUBJECT ROUTINE
SUBJECT TABLE
SUBLANGUAGE
SUBQUERY
SUBTABLE
SUBTRANSACTION
SUBTYPE
SUBVERT
SUBVIEW
SUCCESS
SUMMARY VIEW
SUPER KEY
SUPERTABLE
SUPERTYPE
SYBASE
SYNONYM
SYNTAX
SYNTAX RULE
SYSTEM
SYSTEM CATALOG
SYSTEM GENERATED
SYSTEM R
SYSTEM_USER
TABLE
TABLE CONSTRUCTOR
TABLE ELEMENT
TABLE EXPRESSION
TABLE OPERATOR
TABLE REFERENCE
TABLE SUBQUERY
TABLE VALUE
TABLESPACE
TARGET SPECIFICATION
TAUTOLOGY
TECHNICAL CORRIGENDUM
TEMPORAL
TEMPORARY
TENTATIVELY
TERMINAL
TERMINATOR
TERNARY RELATION
THETA JOIN
THIRD NORMAL FORM
THREE-VALUED LOGIC
TIME
TIME ZONE
TIMEOUT
TIMESTAMP
TIMESTAMPING
TOKEN
TRACE FILE
TRAILING
TRANSACTION
TRANSACTION STATEMENT
TRANSFORM
TRANSIENT
TRANSLATE
TRANSLATION
TRANSLATOR DLL
TRIADIC
TRIGGER
TRIGRAPH
TRIM
TRUE
TRUNCATION
TUPLE
TWO-PHASE COMMIT
TYPE
TYPE INDICATOR
TYPE-PRESERVING
TYPED TABLE
UDT
UNBIND
UNDER
UNDERLINE
UNDERLYING
UNDERSCORE
UNICODE
UNION
UNION COMPATIBLE
UNION JOIN
UNIQUE
UNIQUE INDEX
UNIT OF WORK
UNIVERSAL TIME
UNIX
UNKNOWN
UNNAMED
UNQUOTED
UPDATABLE
UPDATE
UPDATE RULE
UPPER
UPPER CASE
USAGE
USER
USER DEFINED
USER DEFINED TYPE
USER DESC
USER GENERATED
USER IDENTIFIER
USER TABLES
UTC
VALID
VALIDATION
VALUE
VALUE SPECIFICATION
VALUES
VARCHAR
VARIABLE
VARIABLE-LENGTH
VARIABLE-LENGTH
VARYING
VENDOR
VERB
VERBOSE CODE
VERSION
VERSIONING
VIEW
VIEW COLUMN LIST
VIEW DEFINITION
VIEWED TABLE
VIOLATE
VIRTUAL COLUMN
VIRTUAL TABLE
WARNING
WATCOM SQL
WHENEVER
WHERE CLAUSE
WHILE
WHITE SPACE
WIDE CHAR
WILDCARD
WRITE
WRITE-AHEAD CACHE
X/OPEN
X3
YEAR-MONTH INTERVAL
ZERO BASED INDEXING
ZONE
[]
_
{}
|
||