This window is used for creating, displaying and altering views (and summary tables). It is one of the forms of the Manage Object window. That section has general information about this window, including the use of the buttons and menu items.
This window is part of the Administration Component of AQT.
You can activate this window in the following ways:
The window has three parts, described in sections below:
Shows the miscellaneous properties of the view, such as Description and Check Option. The properties you see will differ depending on your database type.
When creating or altering a view, you will also see a checkbox Include Column List. This specifies whether the column list is to be included in your view definition. This is discussed under View Columns.
Displays the query that your view is based on, which will vary depending on where Manage View was started:
You can amend this view text.
View Columns are the names of the columns in your view. By specifying these, your view can have different column names than the column names in your query.
When creating or altering a view:
When you alter a View, AQT will do this by dropping the existing view then creating it with your new definition. If the Create fails, you will no longer have the view in your database.
In this case, do not exit this window or hit Refresh - otherwise the view will be gone forever.
You must correct the definition so that the view is created successfully. If you cannot do this, do a Preview and save the Create statement in a file to correct at a later time.
This warning does not apply to Oracle (for which AQT uses Create or Replace View) or SQL Server (for which AQT uses Alter View).
This window is also used for managing DB2/UDB Summary Tables. A Summary Table, also called a Materialised Query Table, is a table which is based on the result of a query. It is much like a view, except that the data actually exists (unlike a view, which is just a definition).
Defining a Summary Table is very similar to defining a view, so much of the discussion above still applies.