Neoview SQL Reference Manual (R2.2)

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
80 SQL Statements