Page History
Aqua Data Studio provides visual editors for creating and editing Views and Triggers. By navigating the schema browser you may locate the Views container or the Triggers container.
...
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.
|
|
|
|
| 1. Connect to Server | 2. Right-Click Views | 3. Name and Write View | 4. Preview View SQL |
...
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 |
...