View_Table_Usage View

Identifies the table on which the catalog's views are dependent.

This view is part of the ANSI SQL-2 standard Information Schema.

 

Column

Data Type

N

Description

RECORD_NUMBER

integer

n

unique identifier for this record of metadata

VIEW_CATALOG

identifier

n

view catalog (currently always CONNXDB)

VIEW_SCHEMA

identifier

n

view schema

VIEW_NAME

identifier

n

view name

TABLE_CATALOG

identifier

n

table catalog

TABLE_SCHEMA

identifier

n

table schema

TABLE_NAME

identifier

n

table name