Neoview Database Administrator's Guide (R2.2)

3. Right-click the table you want to rename and select Rename to start the Rename Table
Wizard. Enter the new name and select the Cascade check box if you want dependent objects
to reflect the new name, and then click Finish:
4. DB Admin prompts you to confirm that you want to rename the table. When you click Yes,
it attempts to rename the table and either displays an error or indicates the rename was
successful and displays its information.
For additional information, see DB Admin online help.
Creating Triggers on Tables
A trigger is a mechanism that resides in the database and specifies that when a particular
action—an insert, delete, or update—occurs on a table, DB Admin should automatically perform
one or more additional actions.
Create triggers by providing the following parameters:
• A name for the trigger
• BEFORE or AFTER (a named event)
• The event
• ROW or STATEMENT granularity
• Alias names
• Statement that activates the trigger
• A condition that activates the trigger
Triggers are executed in this order:
1. BEFORE triggered statement
2. Triggering statement
3. Referential actions
4. AFTER triggered statement
Triggers are not supported for statements that reference rowsets.
To create a trigger:
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.
Tables 53