Neoview SQL Reference Manual (R2.4 SP2)

default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP }
ref-spec is:
referenced-table [(column-list)]
table-constraint is:
FOREIGN KEY (column-list) REFERENCES ref-spec NOT ENFORCED
| CHECK (condition)
recalibrate-option is:
| ALTER COLUMN column-name RECALIBRATE
| ALTER COLUMN column-name RECALIBRATE TO
internal-sequence-generator-numeric-value
| ALTER COLUMN column-name RECALIBRATE TO
internal-sequence-generator-numeric-value NO SELECT
basic-sequence-generator-option is:
internal-sequence-generator-increment-by-option
| internal-sequence-generator-maxvalue-option
internal-sequence-generator-increment-by-option is:
INCREMENT BY internal-sequence-generator-numeric-value
internal-sequence-generator-maxvalue-option is:
MAXVALUE internal-sequence-generator-numeric-value
internal-sequence-generator-numeric-value is:
signed-numeric-literal
Syntax Description of ALTER TABLE
name
specifies the current name of the object. See “Database Object Names” (page 230).
NO INSERTLOG | INSERTLOG
specifies whether update and delete operations are recorded in the table’s IUD log. This
attribute supports materialized views.
When a table is defined with the INSERTLOG attribute, logging operations ignore delete
and update operations and log inserts only. This logging is needed to maintain ON REQUEST
materialized views. If no ON REQUEST materialized views are defined on the table, this
attribute has no effect.
ADD [COLUMN] column-definition
adds a column to table.
The clauses for the column-definition are:
column-name
specifies the name for the new column in the table. column-name is an SQL identifier.
column-name must be unique among column names in the table. If the column name
is a Neoview SQL reserved word, you must delimit it by enclosing it in double quotes.
For example: "sql".myview. See “Identifiers” (page 257). If a default is not specified,
NULL is used.
data-type
specifies the data type of the values that can be stored in column-name. See “Data Types”
(page 231). If a default is not specified, NULL is used.
DEFAULT default
specifies a default value for the column or specifies that the column does not have a
default value. You can declare the default value explicitly by using the DEFAULT clause,
or you can enable null to be used as the default by omitting both the DEFAULT and NOT
ALTER TABLE Statement 45