SYSCAT.NICKNAMES catalog view
Each row represents a nickname.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TABSCHEMA | VARCHAR (128) | Schema name of the nickname. | |
TABNAME | VARCHAR (128) | Unqualified name of the nickname. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the table, view, alias, or nickname. | |
OWNERTYPE | CHAR (1) |
|
|
STATUS | CHAR (1) | Status of the object.
|
|
CREATE_TIME | TIMESTAMP | Time at which the object was created. | |
STATS_TIME | TIMESTAMP | Y | Time at which any change was last made to recorded statistics for this object. The null value if statistics are not collected. |
COLCOUNT | SMALLINT | Number of columns, including inherited columns (if any). | |
TABLEID | SMALLINT | Internal logical object identifier. | |
TBSPACEID | SMALLINT | Internal logical identifier for the primary table space for this object. | |
CARD | BIGINT | Total number of rows in the table; -1 if statistics are not collected. | |
NPAGES | BIGINT | Total number of pages on which the rows of the nickname exist; -1 if statistics are not gathered. | |
FPAGES | BIGINT | Total number of pages; -1 if statistics are not gathered. | |
OVERFLOW | BIGINT | Total number of overflow records; -1 if statistics are not gathered. | |
PARENTS | SMALLINT | Y | Number of parent tables for this object; that is, the number of referential constraints in which this object is a dependent. |
CHILDREN | SMALLINT | Y | Number of dependent tables for this object; that is, the number of referential constraints in which this object is a parent. |
SELFREFS | SMALLINT | Y | Number of self-referencing referential constraints for this object; that is, the number of referential constraints in which this object is both a parent and a dependent. |
KEYCOLUMNS | SMALLINT | Y | Number of columns in the primary key. |
KEYINDEXID | SMALLINT | Y | Index identifier for the primary key index; 0 or the null value if there is no primary key. |
KEYUNIQUE | SMALLINT | Number of unique key constraints (other than the primary key constraint) defined on this object. | |
CHECKCOUNT | SMALLINT | Number of check constraints defined on this object. | |
DATACAPTURE | CHAR (1) |
|
|
CONST_CHECKED | CHAR (32) |
|
|
PARTITION_MODE | CHAR (1) | Reserved for future use. | |
STATISTICS_PROFILE | CLOB (10M) | Y | RUNSTATS command used to register a statistical profile for the object. |
ACCESS_MODE | CHAR (1) | Access restriction state of the object. These states only
apply to objects that are in set integrity pending state or to objects
that were processed by a SET INTEGRITY statement. Possible values
are:
|
|
CODEPAGE | SMALLINT | Code page of the object. This is the default code page used for all character columns, triggers, check constraints, and expression-generated columns. | |
REMOTE_TABLE | VARCHAR (128) | Y | Unqualified name of the specific data source object (such as a table or a view) for which the nickname was created. |
REMOTE_SCHEMA | VARCHAR (128) | Y | Schema name of the specific data source object (such as a table or a view) for which the nickname was created. |
SERVERNAME | VARCHAR (128) | Y | Name of the data source that contains the table or view for which the nickname was created. |
REMOTE_TYPE | CHAR (1) | Y | Type of object at the data source.
|
CACHINGALLOWED | VARCHAR (1) |
|
|
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the table, view, alias, or nickname. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|