Neoview SQL Reference Manual (R2.4)

the schema portions of the name you specify in constraint, Neoview SQL expands
the constraint name by using the schema for table. See “Database Object Names” (page 228).
If you do not specify a constraint name, Neoview SQL constructs an SQL identifier as the
name for the constraint in the schema for table. The identifier consists of the fully qualified
table name concatenated with a system-generated unique identifier. For example, a
constraint on table A.B.C might be assigned a name such as A.B.C_123..._01... .
DROP CONSTRAINT constraint [RESTRICT | CASCADE]
drops a constraint from the table.
If you drop a constraint, Neoview SQL drops its dependent index if Neoview SQL originally
created the same index. If the constraint uses an existing index, the index is not dropped.
The default is RESTRICT.
CONSTRAINT constraint
specifies a name for the column or table constraint. constraint must have the same
schema as table and must be unique among constraint names in its schema. If you omit
the schema portions of the name you specify in constraint, Neoview SQL expands
the constraint name by using the schema for table. See “Database Object Names” (page 228).
If you do not specify a constraint name, Neoview SQL constructs an SQL identifier as the
name for the constraint in the schema for table. The identifier consists of the fully qualified
table name concatenated with a system-generated unique identifier. For example, a
constraint on table A.B.C might be assigned a name such as A.B.C_123..._01... .
RENAME TO new-name[CASCADE]
changes the logical name of the object within the same schema.
new-name
specifies the new name of the object after the RENAME TO operation occurs.
CASCADE
specifies that indexes and constraints on the renamed object will be renamed.
column data-type
specifies the name and data type for a column in the table.
column is an SQL identifier. column must be unique among column names in the table. If
the name is a Neoview SQL reserved word, you must delimit it by enclosing it in double
quotes. Such delimited parts are case-sensitive. For example: "join".
data-type is the data type of the values that can be stored in column. A default value must
be of the same type as the column, including the character set for a character column. See
“Data Types” (page 229).
INCREMENT BY signed-numeric-literal
increments the current value to obtain the next value. Default is 1 (one). The INCREMENT
BY value cannot be greater than the maximum value of the data type of the IDENTITY column.
INCREMENT BY can not be zero (0) or less than zero. The INCREMENT BY and MAXVALUE
options can only be altered one at a time.
MAXVALUE signed-numeric-literal
minimum non-negative value of the data type of the IDENTITY column starting the cycle
range. The default is 0 (zero). Cannot be greater than the maximum value of the data type
of the IDENTITY column. Must be greater than the INCREMENT BY value. A numeric value
must be used for MAXVALUE.
48 SQL Statements