Neoview SQL Reference Manual (R2.3)

• If column-attributes are specified and they only contain column-name, then the
specified column-name override any name that was derived from the select query.
create table t(c,d) as select a,b from t1
Table t has 2 columns, c and d, which has the data attributes of columns a and b from table
t1.
• If column-attributes are specified, then they must contain attributes corresponding to
all select list items in the select-query. An error is returned, if there is a mismatch.
create table t(a int) as select b,c from t1
An error is returned. Two items need to be specified as part of the table-attributes.
• column-attributes must specify either the column-name datatype-info pair or just
the column-name for all columns. You cannot specify some columns with just the name
and others with name and datatype.
create table t(a int, b) as select c,d from t1
An error is returned.
This section shows the file attributes, such as partitioning information and clustering keys, which
can be specified for the table being created. All the file options that can be specified during a
regular CREATE statement can be specified during a CREATE TABLE AS statement.
• If table-attributes are not specified, the table is created as a single partitioned table.
create table t as select * from t1
• Any other file/table options that are allowed and supported by a regular CREATE statement,
can be specified for a CREATE TABLE AS statement and are used as follows:
create table t max table size 1000 as
select * from t1
create table t(a int not null) hash partition by (a) as
select * from t1
CREATE TABLE Statement 81