11.2.11 Checking dependent viewed tables

By retrieving data from a dictionary table, you can check dependent viewed tables. The following shows an example of retrieving data from a dictionary table.

Example:

This example checks the viewed tables that depend on the CUSTOMER table defined by HADB user ADBUSER01.

Execute the following SELECT statement to make a retrieval from a dictionary table.

SELECT "MV"."TABLE_SCHEMA","MV"."TABLE_NAME"
    FROM  "MASTER"."SQL_VIEW_TABLE_USAGE" "MVU"
         ,"MASTER"."SQL_VIEWS" "MV"
      WHERE "MVU"."TABLE_SCHEMA"='ADBUSER01'
        AND "MVU"."TABLE_NAME" = 'CUSTOMER'
        AND "MV"."TABLE_SCHEMA" = "MVU"."VIEW_SCHEMA"
        AND "MV"."TABLE_NAME" = "MVU"."VIEW_NAME"

Retrieval result

TABLE_SCHEMA TABLE_NAME
------------ ----------
ADBUSER01    CUSTOMER30s
ADBUSER01    CUSTOMER40s
ADBUSER02    CUSTOMER90s

In the retrieval result, a list of dependent viewed tables is displayed.

To Page Top