Contains one row for each table, view, or alias that is created. All
of the catalog tables and views have entries in the SYSCAT.TABLES
catalog view.
Table 90. SYSCAT.TABLES Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TABSCHEMA | CHAR(8) |
| Qualified name of the table, view, or alias. |
TABNAME | VARCHAR(18) |
| |
DEFINER | CHAR(8) |
| User who created the table, view, or alias. |
TYPE | CHAR(1) |
| The type of object:
A=Alias S=Summary table T=Table V=View |
STATUS | CHAR(1) |
| The type of object:
N=Normal table, view or alias C=Check pending on table X=Inoperative view |
BASE_TABSCHEMA | CHAR(8) | Yes | If TYPE=A, these columns identify the table, view, or alias that is referenced by this alias; otherwise they are null. |
BASE_TABNAME | VARCHAR(18) | Yes | |
CREATE_TIME | TIMESTAMP |
| The timestamp indicating when the object was created. |
STATS_TIME | TIMESTAMP | Yes | Last time when any change was made to recorded statistics for this table. Null if no statistics available. |
COLCOUNT | SMALLINT |
| Number of columns in table. |
TABLEID | SMALLINT |
| Internal table identifier. |
TBSPACEID | SMALLINT |
| Internal identifier of primary table space for this table. |
CARD | INTEGER |
| Total number of rows in the table; -1 if statistics are not gathered or the row describes a view or alias. |
NPAGES | INTEGER |
| Total number of pages on which the rows of the table exist; -1 if statistics are not gathered or the row describes a view or alias; -2 for a subtable. |
FPAGES | INTEGER |
| Total number of pages; -1 if statistics are not gathered or the row describes a view or alias; -2 for a subtable. |
OVERFLOW | INTEGER |
| Total number of overflow records in the table; -1 if statistics are not gathered or the row describes a view or alias; -2 for a subtable. |
TBSPACE | VARCHAR(18) | Yes | Name of primary table space for the table. If no other table space is specified, all parts of the table are stored in this table space. Null for aliases and views. |
INDEX_TBSPACE | VARCHAR(18) | Yes | Name of table space that holds all indexes created on this table. Null for aliases and views, or if the INDEX IN clause was omitted or specified with the same value as the IN clause of the CREATE TABLE statement. |
LONG_TBSPACE | VARCHAR(18) | Yes | Name of table space that holds all long data (LONG or LOB column types) for this table. Null for aliases and views, or if the LONG IN clause was omitted or specified with the same value as the IN clause of the CREATE TABLE statement. |
PARENTS | SMALLINT | Yes | Number of parent tables of this table (the number of referential constraints in which this table is a dependent). |
CHILDREN | SMALLINT | Yes | Number of dependent tables of this table (the number of referential constraints in which this table is a parent). |
SELFREFS | SMALLINT | Yes | Number of self-referencing referential constraints for this table (the number of referential constraints in which this table is both a parent and a dependent). |
KEYCOLUMNS | SMALLINT | Yes | Number of columns in the primary key of the table. |
KEYINDEXID | SMALLINT | Yes | Index ID of the primary index. This field is null or 0 if there is no primary key. |
KEYUNIQUE | SMALLINT |
| Number of unique constraints (other than primary key) defined on this table. |
CHECKCOUNT | SMALLINT |
| Number of check constraints defined on this table. |
DATACAPTURE | CHAR(1) |
|
Y=Table participates in data replication N=Does not participate |
CONST_CHECKED | CHAR(32) |
| Byte 1 represents foreign key constraints. Byte 2 represents check
constraints. Byte 3 represents constraint
Datalink_Reconcile_Pending. Byte 4 represents constraint
Datalink_Reconcile_Not_Possible. Byte 5 represents summary
table. Other bytes are reserved. Encodes constraint information
on checking. Values:
Y=Checked by system U=Checked by user N=Not checked (pending) |
PMAP_ID | SMALLINT | Yes | Identifier of the partitioning map used by this table. Null for aliases and views. |
PARTITION_MODE | CHAR(1) |
| Mode used for tables in a partitioned database.
Blank for aliases, views and tables in single partition nodegroups with no partitioning key defined. |
LOG_ATTRIBUTE | CHAR(1) |
|
0=Default logging 1=Table created not logged initially |
PCTFREE | SMALLINT |
| Percentage of each page to be reserved for future inserts. Can be changed by ALTER TABLE. |
REMARKS | VARCHAR(254) | Yes | User-provided comment. |