View_Column_Usage View

Identifies the columns 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

COLUMN_NAME

identifier

n

column name