Neoview SQL Reference Manual (R2.4 SP2)

If you do not specify MAX TABLE SIZE, a table is created with the following default
characteristics:
• For a partitioned table, the space is 25 MB times number of partitions. The maximum
size a partitioned table can reach is the size of the disk at the time of table creation. When
a partitioned table is created, the table is automatically partitioned across all the disk
volumes in the disk pool.
• For a non-partitioned table, the space allocated is 25 MB.
DISK POOL pool_number
causes the table to be created in the specified pool number. The value of pool_number is
an unsigned integer. Zero (0) is not a valid pool number. If pool_number is greater than
the number of pools or if pool_number is an invalid number, an error is generated. See
“Considerations for DISK POOL” (page 91).
NO INSERTLOG | INSERTLOG
specifies whether update and delete operations are recorded in the table’s IUD log, if one
exists.
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 affect.
LOAD IF EXISTS
loads data into an existing table. Must be used with AS select-query. See “Considerations
for LOAD IF EXISTS of CREATE TABLE AS” (page 84).
AS select-query
specifies a select query which is used to populate the created table. A select query can be any
SQL select statement.
column data-type
specifies the name and data type for a column in the table. At least one column definition is
required in a CREATE TABLE statement.
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. “Data
Types” (page 231). Data type also includes case specific information, such as UPSHIFT.
DEFAULT default | NO DEFAULT
specifies a default value for the column or specifies that the column does not have a default
value. “DEFAULT Clause” (page 302).
CREATE TABLE Statement 75