Page History
...
To create a View, connect to a database server, right-click on the Views container for a database and select Create View from the menu. When the Create View property window appears, select the schema, name the view and enter the SQL you wish to be used in the view. Once the SQL is entered, you can view it in the Preview SQL tab. Click ok to finish.
To edit or ALTER an existing View, right-click on the View within the Views container and select Alter View.
...
To create a Trigger, connect to a database server, right-click on the Triggers container for a database and select Create Trigger from the menu. When the Create Trigger property window appears, select the schema, name the Trigger and enter the SQL you wish to be used in the view. Once the SQL is entered, you can view it in the Preview SQL tab. Click ok to finish. What causes a trigger to fire varies depending on the database vendor and version.
|
|
|
| |||
| 1. Connect to Server | 2. Right Click Triggers | 3. Name and Write Trigger | 4. Preview Trigger SQL |
ALTER
To edit or ALTER an existing Trigger, right-click on the Trigger within the Triggers container and select Alter Trigger.
...