Neoview SQL Reference Manual (R2.4 SP2)

CREATE TABLE Statement...................................................................................................................72
Syntax Description of CREATE TABLE...........................................................................................73
Considerations for CREATE TABLE................................................................................................78
Considerations for CREATE SET TABLE........................................................................................78
Considerations for CREATE VOLATILE TABLE............................................................................79
Considerations for CREATE TABLE LIKE......................................................................................81
Considerations for LOAD IF EXISTS of CREATE TABLE AS.........................................................84
Considerations for CREATE TABLE AS..........................................................................................84
Reserved Table Names.....................................................................................................................86
Authorization and Availability Requirements................................................................................86
Limits for Tables..............................................................................................................................86
Calculating Row Size.......................................................................................................................86
Creating Partitions Automatically...................................................................................................87
Generating Values For an IDENTITY Column................................................................................87
Neoview SQL Extensions to CREATE TABLE................................................................................91
Considerations for DISK POOL.......................................................................................................91
Examples of CREATE TABLE..........................................................................................................92
Examples of CREATE SET TABLE..................................................................................................93
Example of CREATE SET VOLATILE TABLE.................................................................................93
Examples of CREATE TABLE AS....................................................................................................93
CREATE TRIGGER Statement..............................................................................................................95
Syntax Description of CREATE TRIGGER......................................................................................95
Considerations for CREATE TRIGGER...........................................................................................96
Examples of CREATE TRIGGER.....................................................................................................99
CREATE VIEW Statement...................................................................................................................101
Syntax Description of CREATE VIEW...........................................................................................101
Considerations for CREATE VIEW...............................................................................................102
Examples of CREATE VIEW..........................................................................................................104
DELETE Statement..............................................................................................................................106
Syntax Description of DELETE......................................................................................................106
Considerations for DELETE..........................................................................................................108
Examples of DELETE.....................................................................................................................109
DROP INDEX Statement.....................................................................................................................111
Syntax Description of DROP INDEX.............................................................................................111
Considerations for DROP INDEX.................................................................................................111
Example of DROP INDEX.............................................................................................................111
DROP MATERIALIZED VIEW Statement..........................................................................................112
Syntax Description of DROP MATERIALIZED VIEW..................................................................112
Authorization and Availability Requirements..............................................................................112
Example of DROP MATERIALIZED VIEW..................................................................................112
DROP MVGROUP Statement.............................................................................................................113
Syntax Description of DROP MVGROUP.....................................................................................113
Considerations for DROP MVGROUP..........................................................................................113
Example of DROP MVGROUP......................................................................................................113
DROP SCHEMA Statement................................................................................................................114
Syntax Description of DROP SCHEMA........................................................................................114
Considerations for DROP SCHEMA.............................................................................................114
Example of DROP SCHEMA.........................................................................................................114
DROP SYNONYM Statement.............................................................................................................115
Syntax Description of DROP SYNONYM ....................................................................................115
Considerations for DROP SYNONYM..........................................................................................115
Example of DROP SYNONYM......................................................................................................115
DROP TABLE Statement.....................................................................................................................116
Syntax Description of DROP TABLE.............................................................................................116
Considerations for DROP TABLE..................................................................................................116
Table of Contents 5