Parameters—Create Table Statement

3. Statements : OpenROAD SQL Statements : Create Table Statement : Parameters—Create Table Statement

Share this page

This statement has the following parameters:

table_name

Defines the name of the new table, which must be a valid object name.

column_specification

Defines the characteristics of the column, as described in Column Specification (see Column Specification—Define Column Characteristics).

with_clause

Consists of a comma-separated list of one or more of the following options, described in detail in With_Clause for Create Table:

• location = (location_name {, location_name})

• [no]journaling

• [no]duplicates

• page_size = n

• security_audit = (audit_opt {, audit_opt})

• security_audit_key = (column)

• [no]autostruct

• encryption = AES128|AES192|AES256, [aeskey=hex-aes-key,] passphrase = 'encryption-passphrase'

Additional options on the With_Clause for Create Table...as Select are as follows:

• structure = HASH | HEAP | ISAM | BTREE

• key = (column_name {, column_name})

• fillfactor = n

• minpages = n

• maxpages = n

• leaffill = n

• nonleaffill = n

• compression[= ([[NO]KEY] [,[NO]DATA])] | NOCOMPRESSION

• allocation = n

• extend = n

• priority = n

subselect

Specifies a select clause, described in detail in Select (interactive) in the Ingres SQL Reference Guide. Also see Using Create Table...As Select (see Using Create Table...As Select).

Note: Subselect cannot be used when creating a table in one or more raw locations—that is, create table raw_table as select... with location = (raw_loc).