VIEWS

Prerequisites

You have generated the demo data for the SQL Tutorial.

Log on to the demo database instance DEMODB as user MONA.

Define view tables. Proceed as described in SQL Tutorial, View Tables.

Examples

You can use the system table VIEWS to determine the following database information, among other things:

?     All privileges of the view table CUSTOMER_ADDR

SELECT privileges
  FROM DOMAIN.VIEWS
    WHERE schemaname = 'HOTEL'
      AND viewname = 'CUSTOMER_ADDR'

?     All view tables with their comments that the current user can see without being the owner

SELECT schemaname, viewname, comment
  FROM DOMAIN.VIEWS
    WHERE owner <> 'MONA'

Definition text of a view table: see VIEWDEFS

Existence of a view table: see TABLES

Synonym for a view table: see SYNONYMS

Tables and columns forming the basis for a view table: see VIEWCOLUMNS