Neoview SQL Reference Manual (R2.4)

Syntax Description of CREATE TABLE...........................................................................................72
Considerations for CREATE TABLE................................................................................................76
Considerations for CREATE SET TABLE........................................................................................76
Considerations for CREATE VOLATILE TABLE............................................................................77
Considerations for CREATE TABLE LIKE......................................................................................79
Considerations for CREATE TABLE AS..........................................................................................82
Reserved Table Names.....................................................................................................................83
Authorization and Availability Requirements................................................................................84
Limits for Tables..............................................................................................................................84
Calculating Row Size.......................................................................................................................84
Creating Partitions Automatically...................................................................................................84
Generating Values For an IDENTITY Column................................................................................85
Neoview SQL Extensions to CREATE TABLE................................................................................89
DISK POOL......................................................................................................................................89
Examples of CREATE TABLE..........................................................................................................89
Examples of CREATE SET TABLE..................................................................................................90
Example of CREATE SET VOLATILE TABLE.................................................................................91
Examples of CREATE TABLE AS....................................................................................................91
CREATE TRIGGER Statement..............................................................................................................93
Syntax Description of CREATE TRIGGER......................................................................................93
Considerations for CREATE TRIGGER...........................................................................................94
Examples of CREATE TRIGGER.....................................................................................................97
CREATE VIEW Statement.....................................................................................................................99
Syntax Description of CREATE VIEW.............................................................................................99
Considerations for CREATE VIEW...............................................................................................100
Examples of CREATE VIEW..........................................................................................................103
DELETE Statement..............................................................................................................................105
Syntax Description of DELETE......................................................................................................105
Considerations for DELETE..........................................................................................................107
Examples of DELETE.....................................................................................................................108
DROP INDEX Statement.....................................................................................................................109
Syntax Description of DROP INDEX.............................................................................................109
Considerations for DROP INDEX.................................................................................................109
Example of DROP INDEX.............................................................................................................109
DROP MATERIALIZED VIEW Statement..........................................................................................110
Syntax Description of DROP MATERIALIZED VIEW..................................................................110
Example of DROP MATERIALIZED VIEW..................................................................................110
DROP MVGROUP Statement.............................................................................................................111
Syntax Description of DROP MVGROUP.....................................................................................111
Considerations for DROP MVGROUP..........................................................................................111
Example of DROP MVGROUP......................................................................................................111
DROP SCHEMA Statement................................................................................................................112
Syntax Description of DROP SCHEMA........................................................................................112
Considerations for DROP SCHEMA.............................................................................................112
Example of DROP SCHEMA.........................................................................................................112
DROP SYNONYM Statement.............................................................................................................113
Syntax Description of DROP SYNONYM ....................................................................................113
Considerations for DROP SYNONYM..........................................................................................113
Example of DROP SYNONYM......................................................................................................113
DROP TABLE Statement.....................................................................................................................114
Syntax Description of DROP TABLE.............................................................................................114
Considerations for DROP TABLE..................................................................................................114
Examples of DROP TABLE............................................................................................................114
DROP TRIGGER Statement................................................................................................................115
Syntax Description of DROP TRIGGER........................................................................................115
Table of Contents 5