Chapter 9 SQL Statements
379
♦
role-name An identifier representing the role name of a foreign key.
♦
savepoint-name An identifier that represents the name of a savepoint.
♦
search-condition A condition that evaluates to TRUE, FALSE, or
UNKNOWN.
♦
special-value One of the special values described in "Special values"
on page 247.
♦
statement-label An identifier that represents the label of a loop or
compound statement.
♦
table-list A list of table names, which may include correlation names.
$ For more information, see "FROM clause" on page 532.
♦
table-name An identifier that represents the name of a table.
♦
userid An identifier representing a user name.
♦
variable-name An identifier that represents a variable name.
Syntax conventions
The following conventions are used in the SQL syntax descriptions:
♦
Keywords All SQL keywords are shown like the words ALTER
TABLE in the following example:
ALTER TABLE [
owner
.]
table-name
♦ Placeholders Items that must be replaced with appropriate identifiers
or expressions are shown like the words owner and table-name in the
following example.
ALTER TABLE [
owner
.]
table-name
♦ Continuation Lines beginning with an ellipsis (…) are a continuation
from the previous line. For example,
ALTER TABLE [
owner
.]
table-name
… ADD
column-definition
[
column-constraint
…
]
♦ Repeating items Lists of repeating items are shown with an element
of the list followed by an ellipsis (three dots), like column-constraint in
the following example:
ADD
column-definition
[
column-constraint
…
]
One or more list elements are allowed. If more than one is specified,
they must be separated by commas.
To Next Page
Loading...