Aqua Data Studio 7.0 provides visual editors for creating database
Storage objects. By navigating the schema browser you may locate
Storage Folder.
View
A view is a stored query accessible as a virtual table composed
of the result set of a query. Views are dynamic - changing the data
in a table alters the data shown in a view
Connect to Server
Click on Views
Propertiesand SQL
Preview SQL
To create an View
Open Create View Dialog
In the Schema Drop down, Select the schema, in which you want
to create the object
Provide a new name for the View in the given space
Specify the SQL for creating the view. Click on Preview
SQL to see the summary
Click on OK and the view is successfully created
Trigger
A Trigger is a procedural code that is automatically executed in
response to certain events on a particular table in a database.
There are two classes of triggers, they are either row triggers or
statement triggers. Each class can be of several types. There are
BEFORE triggers and AFTER triggers. There is also an
INSTEAD OF trigger, which will execute instead of the
triggering statement
Connect to Server
Click on Triggers
Propertiesand SQL
Preview SQL
To create an Trigger
Open Create Trigger Dialog
In the Schema Drop down, Select the schema, in which you want
to create the object
Provide a new name for the Trigger in the given space
Specify the SQL for creating the Trigger. Click on Preview
SQL to see the summary
Click on OK and the Trigger is successfully created
