Previous Topic: SYSTEM.TABLENext Topic: SYSCA Objects

SYSTEM Tables and SYSCA Views › SYSTEM.VIEWDEP

SYSTEM.VIEWDEP

Description

A row of SYSTEM.VIEWDEP identifies a table or view referenced by a view.

View SYSCA.VIEWDEP is defined on SYSTEM.VIEWDEP.

Note: For more information, see SYSCA Objects.

Column name

Column description

Data type

Null specifi- cation

SCHEMA

Schema-name qualifier of the dependent view.

CHAR(18)

NOT NULL

NAME

Dependent view name.

CHAR(18)

NOT NULL

SEQUENCE

Sequence number of the table or view referenced in the dependent view.

SMALLINT

NOT NULL

REFSCHEMA

Schema-name qualifier of the table or view referenced in the dependent view.

CHAR(18)

NOT NULL

REFTABLE

Name of the table or view referenced in the dependent view.

CHAR(18)

NOT NULL

REFTYPE

Type of the table or view referenced in the dependent view:

  • F—Function
  • N—Record in a non-SQL-defined schema
  • P—Table procedure
  • R—Procedure
  • T—Base table
  • V—View

CHAR(1)

NOT NULL

FILLER

Reserved for future use.

BINARY(5)

NOT NULL