Neoview Database Administrator's Guide (R2.2)

9. DB Admin prompts you to confirm that you want to create the trigger. When you click Yes,
it attempts to create the trigger and either displays an error or indicates the rename was
successful and displays its information.
For additional information, see DB Admin online help.
Enabling or Disabling Reorganize and Update Statistics on Tables
The owner of a schema can enable and disable Reorganize and Update Statistics for a table.
1. Start DB Admin and log on using the user ID that owns the schema that the table resides in
or log on as a user authorized to grant privileges to others on that table.
2. Click the Database tab, then navigate to the schema and table you want to change.
3. Right-click the table you want to change and select Enable Reorganize to enable
reorganization, Disable Reorganize to disable reorganization, Enable Update Statistics to
enable update statistics, or Disable Update Statistics to disable that operation.
The state of the table will be reflected in the items that are available: if Reorganized is already
enabled on a table, Enable Reorganize will be grayed out.
Enabling or Disabling Triggers on Tables
1. Start DB Admin and log on using the user ID that created the table or log on as a user
authorized to grant privileges to others on that table.
2. Click the Database tab, then navigate to the schema and table where you want to create a
trigger.
3. Right-click the table for which you want to create a trigger and select Enable all triggers to
enable triggers, or Disable all triggers to disable them.
Dropping (Deleting) Tables
1. Start DB Admin and log on using the user ID that created the table or log on as a user
authorized to drop the table.
2. Click the Database tab, then navigate to the schema and table you want to delete.
3. Right-click the table name and then select Drop.
4. DB Admin prompts you to select RESTRICT or CASCADE to indicate if you want to drop
dependent objects. Select Drop:
56 Managing Database Objects