SYS_TABLES

Information on base tables and views in the database.

Column name

Data type

Contents

TABLE_SCHEMA

CHAR (31)

Name of the schema to which the table
belongs

TABLE_NAME

CHAR (31)

Table name

TABLE_TYPE

VARCHAR (18)

BASE TABLE, VIEW or
ABSTRACT TABLE

TABLE_ID

SMALLINT

Identification number

of the base table or of the abstract
table When TABLE_ID >= 30720 the
table is a partitioned table.

NULL value for views

SPACE_NAME

CHAR (18)

Name of the space

in which the (non-partitioned) table is
stored

_PARTITIONS_

in the case of a partitioned table

NULL value in all other cases

SPACE_ID

SMALLINT

Identification number

of the space. In the case of a
partitioned table 32767 is output

NULL value in all other cases

TABLE_STYLE

VARCHAR (6)

OLDEST OLD NEW

CALL DML only table CALL DML/SQL table SQL table

NULL value in all other cases

TABLE_DATE

TIMESTAMP (3)

Time of creation or time of last ALTER
TABLE

VIEW_DEFINITION

VARCHAR
(32000)

Query expression

that defines the view for views

NULL value in all other cases

TABLE_PRIMARY_KEY

CHAR (1)

S	Single primary key
C	Compound primary key
NULL	value else

CHECK_OPTION

VARCHAR (8)

NONE

No check option set

CASCADED

Check option set

NULL value in all other cases

IS_UPDATABLE

VARCHAR (3)

YES	View is updatable
NO	View is not updatable
NULL	value in all other cases

TEMPORARY_VIEW

VARCHAR (3)

YES	View is temporary
NO	View is permanent
NULL	value in all other cases

Table 135: SYS_TABLES view of the SYS_INFO_SCHEMA