Views

From RapidSQL
Jump to: navigation, search

Go Up to Supported Objects

Views are SQL queries stored in the system catalog that customize the display of data contained in one or more tables. Views behave like tables because you can query views and perform data manipulation operations on them. However, views do not actually store any data. Instead, they depend on data contained in their base tables. Views let you:

  • View a customized selection of data from one or more tables. As a result, you can display data more cogently to different sets of users, even though the underlying data is the same.
  • Restricting access to a defined set of rows and columns.

Creating and editing

Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

DB2 LUW DB2 z/OS ORCL PSTGRS * SQL SVR SYB ASE SYB IQ SYB IQ

Build Query

Change Owner

Change Schema

Compile

Create Alias

Create Synonym

Describe

Drop

Extract

Generate Package/Procedure/Statement

Hide Text

Migrate

Object Properties

Refresh Materialized View

Rename

Report

Schema (Object Action)

Select * From

Transfer Ownership

Update Statistics