Views

Now the definitions of views are to be displayed. From the table 'domain.defs', a user can retrieve view definitions that relate to tables for which he has privileges.

Let the following view be defined:

CREATE VIEW v1 AS SELECT *

FROM customer WHERE account >= 0

SELECT definition

FROM domain.viewdefs

WHERE viewname = 'V1'

To see a list of all views, specify:

SELECT * FROM domain.views

Information similar to that displayed for the select issued on the table 'domain.tables' is shown.