Base_Tables View

Lists the base tables defined in the catalog.

 

Column

Data Type

N

Description

RECORD_NUMBER

integer

n

unique identifier for this record of metadata

TABLE_CATALOG

identifier

n

table catalog

TABLE_SCHEMA

identifier

n

table schema

TABLE_NAME

identifier

n

table name

DB_NR

integer

n

Adabas database number

FILE_NR

integer

n

Adabas file number

TABLE_LEVEL

integer

n

table level: 0, 1, 2