BASE_TABLES

Information on base tables. The current authorization identifier must have at least one table privilege for the base table or the UTILITY privilege for the database.

Column name

Data type

Contents

TABLE_CATALOG

CHAR (18)

Database name

TABLE_SCHEMA

CHAR (31)

Name of the schema to which the table
belongs

TABLE_NAME

CHAR (31)

Name of the base table

SPACE_NAME

CHAR (18)

Name of the space in which the base
table is stored. If the table is
partitioned, “_PARTITIONS_” is output
as the name of the space.

TABLE_STYLE

VARCHAR (6)

OLDEST	CALL DML only table
OLD	CALL DML/SQL table
NEW	SQL table

Table 63: BASE_TABLES view of the INFORMATION_SCHEMA