Views
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
- Views Wizard (DB2 LUW) and Views Editor (IBM DB2 LUW)
- Views Wizard (DB2 Z/OS) and Views Editor (IBM DB2 Z/OS)
- Views Wizard (Oracle) and Views Editor (Oracle)
- Views Wizard (PostgreSQL) and Views Editor (PostgreSQL)
- Views Wizard (SQL Server) and Views Editor (SQL Server)
- Views Wizard (Sybase ASE) and Views Editor (Sybase ASE)
- 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 | |
---|---|---|---|---|---|---|---|---|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |||
✓ |
||||||||
✓ |
||||||||
✓ |
||||||||
✓ |
✓ |
|||||||
✓ |
✓ |
|||||||
✓ |
✓ |
✓ |
✓ |
✓ |
||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
||||
✓ |
||||||||
✓ |
✓ |
✓ |
✓ |
✓ |
||||
✓ |
✓ | |||||||
✓ |
||||||||
✓ |
✓ |
✓ |
✓ |
✓ | ||||
✓ |
✓ |
✓ |
✓ |
✓ |
||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
||||||||
✓ |