Neoview Database Administrator's Guide (R2.2)

Guidelines for Database Administrators..............................................................................................33
Neoview SQL Table Options.................................................................................................................33
5 Managing Database Objects.....................................................................................37
Schemas.................................................................................................................................................38
Displaying Schemas and Their Objects...........................................................................................38
Creating Schemas............................................................................................................................39
Displaying Schema DDL Information.............................................................................................39
Dropping (Deleting) Schemas.........................................................................................................40
Tables.....................................................................................................................................................40
Creating Tables ...............................................................................................................................40
Creating Tables From Existing Tables.............................................................................................44
Using the Create Table Tool to Import DDL From a File................................................................45
Granting and Revoking Access (Privileges) to a Table....................................................................47
Displaying Tables and Their Properties..........................................................................................47
Displaying Table DDL Information.................................................................................................51
Adding Columns to a Table.............................................................................................................51
Changing Table Attributes..............................................................................................................52
Renaming Tables..............................................................................................................................52
Creating Triggers on Tables.............................................................................................................53
Enabling or Disabling Reorganize and Update Statistics on Tables...............................................56
Enabling or Disabling Triggers on Tables........................................................................................56
Dropping (Deleting) Tables.............................................................................................................56
Indexes..................................................................................................................................................57
Creating Indexes..............................................................................................................................57
Displaying Indexes and Their Properties........................................................................................59
Dropping (Deleting) Indexes...........................................................................................................60
Views.....................................................................................................................................................60
Creating Views................................................................................................................................60
Displaying Views and Their Properties..........................................................................................61
Renaming Views..............................................................................................................................62
Dropping (Deleting) Views.............................................................................................................62
Materialized Views...............................................................................................................................63
Creating Materialized Views...........................................................................................................63
Displaying Materialized Views and Their Properties.....................................................................67
Changing Materialized Views.........................................................................................................68
Dropping (Deleting) Materialized Views........................................................................................69
Materialized View Groups....................................................................................................................69
Creating Materialized View Groups...............................................................................................69
Displaying Materialized View Groups and their Properties..........................................................70
Changing Materialized View Groups.............................................................................................71
Dropping (Deleting) Materialized View Groups............................................................................71
Synonyms..............................................................................................................................................72
Creating Synonyms.........................................................................................................................72
Displaying Synonyms and Their Properties...................................................................................73
Changing Synonyms.......................................................................................................................73
Dropping (Deleting) Synonyms......................................................................................................74
Stored Procedures in Java (SPJs)...........................................................................................................74
Displaying Stored Procedures.........................................................................................................74
6 Performing Database Operations...............................................................................77
Schedule Maintain Wizard...................................................................................................................77
Schedule Table Row Deletion...............................................................................................................80
4 Table of Contents