Views

A view is a computed table defined by the result set of its view definition, expressed as a SQL query. You can use views to show database users exactly the information you want to present, in a format you can control.

A regular view describes a view that is recomputed each time you reference the view, and the result set is not stored on disk. This is the most commonly used type of view.

A materialized view describes a view whose result set is precomputed and materialized on disk similar to the contents of a base table. Materialized views are useful in data warehousing scenarios, where frequent queries of the actual base tables can be extremely expensive.

• About Views
  A view is a computed table that may be useful for security purposes, and for tailoring the appearance of database information to make data access straightforward. SAP Sybase IQ provides views that allow you to give names to frequently executed SELECT commands, saving you from having to repeatedly type them.
• Creating a View
  Create a new regular view by defining a SQL query using the Create View wizard.
• Viewing View Data in the Execute SQL Window
  Execute a SELECT * FROM query and display contents of the view in the query results pane of the Execute SQL window.
• Recompiling and Enabling a View
  Recompile and enable a disabled view to make it available for use by the database server. Enabling a view changes the definition of the view but does not change data inside the view.
• Disabling a View
  Disabling a view makes it unusable, but retains the definition of the view in the database. You can enable and recompile the disabled view at a later time. Disabling a view changes the definition of the view but does not change data inside the view.
• Deleting a View
  Delete an enabled or disabled view to remove it from the database. Deleting a view deletes the definition of the view. All data related to the view are virtual, and remain in the underlying tables after deletion.
• Generating View DDL Commands
  Display the data description language SQL code for adding a view to the database. The SQL code can be a useful reference and training tool.
• Viewing or Modifying View Properties
  View or change view properties including the comment, SQL view definition (including the column definition), and permissions. Modifying a view changes the definition of the view but does not change data inside the view.
• View Privilege Summary
  A list of the system privileges and object permissions required to complete the various view tasks.
• View Permissions
  Grant or revoke view permissions to users and roles.
• View Triggers
  Trigger management includes the creation, modification and deletion of triggers on a database object. A trigger is a special form of stored procedure that executes automatically when a statement that modifies data displayed in a view is executed.