SYSIBM.SYSTABLES
SYSIBM.SYSTABLES table
Column name
NAME CREATOR TYPE
DBNAME
TSNAME
| | |
Data type
VARCHAR(18) NOT NULL
CHAR(8) NOT NULL
CHAR(1) NOT NULL
CHAR(8) NOT NULL
CHAR(8) NOT NULL
SMALLINT NOT NULL
SMALLINT NOT NULL
SMALLINT NOT NULL
CHAR(8) NOT NULL
CHAR(8) NOT NULL
CHAR(1) NOT NULL
INTEGER NOT NULL
INTEGER NOT NULL
INTEGER NOT NULL
SMALLINT NOT NULL
CHAR(1) NOT NULL
VARCHAR(254) NOT NULL
Description Use
Name of the table, view, or alias. G
Authorization ID of the owner of the table, view, or alias. G
Type of object: G A Alias
G Created global temporary table
T Table
V View
X Auxiliary table
For a table, or a view of tables, the name of the database that G contains the table space named in TSNAME. For a created
temporary table, an alias, or a view of a view, the value is
DSNDB06.
For a table, or a view of one table, the name of the table space G that contains the table. For a view of more than one table, the
name of a table space that contains one of the tables. For a
created temporary table, the value is SYSPKAGE. Although SYSPKAGE is used as the value, created temporary tables are
not stored in the SYSPKAGE table space. For a view of a view, the value is SYSVIEWS. For an alias, it is SYSDBAUT.
Internal identifier of the database; 0 if the row describes a view, S alias, or created temporary table.
Internal identifier of the table; 0 if the row describes a view, an S alias, or a created temporary table.
Number of columns in the table or view. The value is 0 if the row G describes an alias.
Name of the edit procedure; blank if the row describes a view or G alias or a table without an edit procedure.
Name of the validation procedure; blank if the row describes a G view or alias or a table without a validation procedure.
Whether RESTRICT ON DROP applies: G blank No
Contains one row for each table, view, or alias.
DBID
OBID COLCOUNT EDPROC VALPROC CLUSTERTYPE
NPAGES
PCTPAGES
IBMREQD
REMARKS
Y
Not used Not used
Yes. Neither the table nor any table space or database that contains the table can be dropped.
N
N
Total number of pages on which rows of the table appear. The S value is -1 if statistics have not been gathered, or the row
describes a view, an alias, a created temporary table, or an
auxiliary table. This is an updatable column.
Percentage of active table space pages that contain rows of the S table. A page is termed active if it is formatted for rows, regardless
of whether it contains any. If the table space is segmented, the percentage is based on the number of active pages in the set of segments assigned to the table. The value is -1 if statistics have
not been gathered, or the row describes a view, alias, created temporary table, or auxiliary table. This is an updatable column.
A value of Y indicates that the row came from the basic G machine-readable material (MRM) tape. For all other values, see ¡°Release dependency indicators¡± on page 985.
A character string provided by the user with the COMMENT ON G statement.
1106 SQL Reference