Neoview Database Administrator's Guide (R2.3)

5 Managing Database Objects.....................................................................................35
Schemas.................................................................................................................................................36
Displaying Schemas and Their Objects...........................................................................................36
Creating Schemas............................................................................................................................40
Granting and Revoking Access (Privileges) to a Schema................................................................41
Displaying Schema DDL Information.............................................................................................41
Dropping (Deleting) Schemas.........................................................................................................42
Tables.....................................................................................................................................................42
Creating Tables ...............................................................................................................................43
Creating Tables From Existing Tables.............................................................................................47
Creating Tables Using the Create Table Tool...................................................................................48
Granting and Revoking Access (Privileges) to a Table....................................................................50
Displaying Tables and Their Properties..........................................................................................51
Displaying Table DDL Information.................................................................................................54
Adding Columns to a Table.............................................................................................................55
Changing Table Attributes..............................................................................................................56
Renaming Tables..............................................................................................................................57
Enabling or Disabling Reorganize and Update Statistics on Tables...............................................58
Dropping (Deleting) Tables.............................................................................................................58
Indexes..................................................................................................................................................58
Creating Indexes..............................................................................................................................58
Displaying Indexes and Their Properties........................................................................................62
Dropping (Deleting) Indexes...........................................................................................................62
Triggers.................................................................................................................................................63
About Triggers.................................................................................................................................63
Creating Triggers on Tables.............................................................................................................63
Displaying Triggers and Their Properties.......................................................................................66
Enabling or Disabling Triggers on Tables........................................................................................67
Views.....................................................................................................................................................67
Creating Views................................................................................................................................67
Displaying Views and Their Properties..........................................................................................68
Renaming Views..............................................................................................................................69
Dropping (Deleting) Views.............................................................................................................70
Materialized Views...............................................................................................................................70
Creating Materialized Views...........................................................................................................70
Displaying Materialized Views and Their Properties.....................................................................75
Changing Materialized Views.........................................................................................................76
Dropping (Deleting) Materialized Views........................................................................................77
Materialized View Groups....................................................................................................................77
Creating Materialized View Groups...............................................................................................77
Displaying Materialized View Groups and their Properties..........................................................78
Changing Materialized View Groups.............................................................................................79
Dropping (Deleting) Materialized View Groups............................................................................79
Synonyms..............................................................................................................................................79
Creating Synonyms.........................................................................................................................80
Displaying Synonyms and Their Properties...................................................................................81
Changing Synonyms.......................................................................................................................81
Dropping (Deleting) Synonyms......................................................................................................82
Stored Procedures in Java (SPJs)...........................................................................................................82
Displaying Stored Procedures.........................................................................................................82
6 Performing Database Operations...............................................................................85
Schedule Maintain Wizard...................................................................................................................85
Schedule Table Row Deletion...............................................................................................................88
4 Table of Contents