Db2 object types
The following table shows the abbreviations that Specification uses, and the data types for each part of the object names (in bytes):
Abbreviation | Description | Data type of object name (in bytes) | ||
---|---|---|---|---|
Data type (part 1) | Data type (part 2) | Data type (part 3) | ||
AL | Alias | VARCHAR(128) | VARCHAR(128) | NA |
CK | Check constraint (check) | VARCHAR(128) | VARCHAR(128) | VARCHAR(128) |
DB | Database | VARCHAR(24) 1 | NA | NA |
FK | Foreign key | VARCHAR(128) | VARCHAR(128) | VARCHAR(128) |
IX | Index Auxiliary index XML index | VARCHAR(128) | VARCHAR(128) | NA |
IXA | Orphaned auxiliary index | VARCHAR(128) | VARCHAR(128) | NA |
IXC | Clustering index | VARCHAR(128) | VARCHAR(128) | NA |
IXCT | Clustering index This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXCT2 | Clustering, partitioning index for a table in a partition-by-range table space with relative page numbering This partitioned index is created for a range-partitioned (PBR) table space. | VARCHAR(128) | VARCHAR(128) | NA |
IXG | Unique index that is defined as ROWID GENERATED BY DEFAULT | VARCHAR(128) | VARCHAR(128) | NA |
IXGC | Unique and clustering index that is defined as ROWID GENERATED BY DEFAULT | VARCHAR(128) | VARCHAR(128) | NA |
IXGCT | Unique and clustering index that is defined as ROWID GENERATED BY DEFAULT This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXGT | Unique index that is defined as ROWID GENERATED BY DEFAULT This index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXN | Node ID index for an XML base table | VARCHAR(128) | VARCHAR(128) | NA |
IXP | Primary index | VARCHAR(128) | VARCHAR(128) | NA |
IXPC | Primary and clustering index | VARCHAR(128) | VARCHAR(128) | NA |
IXPCT | Primary and clustering index This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXPT | Primary index This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXR | Unique index that enforces the uniqueness of a nonprimary parent key; referenced by a foreign key | VARCHAR(128) | VARCHAR(128) | NA |
IXRC | Unique and clustering index that enforces the uniqueness of a nonprimary parent key | VARCHAR(128) | VARCHAR(128) | NA |
IXRCT | Unique and clustering index that enforces the uniqueness of a nonprimary parent key This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXRT | Unique index that enforces the uniqueness of a nonprimary parent key This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXS | Index on an expression | VARCHAR(128) | VARCHAR(128) | NA |
IXST | Partitioned index on an expression that is created for a table that uses table-controlled partitioning | VARCHAR(128) | VARCHAR(128) | NA |
IXSU | Unique index on an expression | VARCHAR(128) | VARCHAR(128) | NA |
IXT | Partitioned index that is created for a table that uses table-controlled partitioning | VARCHAR(128) | VARCHAR(128) | NA |
IXT2 | Partitioned index for a table in a partition-by-range table space with relative page numbering | VARCHAR(128) | VARCHAR(128) | NA |
IXU | Unique index | VARCHAR(128) | VARCHAR(128) | NA |
IXUC | Unique and clustering index | VARCHAR(128) | VARCHAR(128) | NA |
IXUCT | Unique and clustering index This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXUT | Unique index This partitioned index is created for a table that uses table-controlled partitioning. | VARCHAR(128) | VARCHAR(128) | NA |
IXV | Index that is defined on an XML column in a base table (TBB or TBBT) This object code replaces the IXX object code. | VARCHAR(128) | VARCHAR(128) | NA |
IXVD | DocID index that is defined on an XML column in a base table (TBB or TBBT) Db2 implicitly creates this index. This object code replaces the IXXD object code. | VARCHAR(128) | VARCHAR(128) | NA |
IXVN | NodeID index that is defined on an XML column in a base table (TBB or TBBT) | VARCHAR(128) | VARCHAR(128) | NA |
IXVU | Unique XML index | VARCHAR(128) | VARCHAR(128) | NA |
IXW | Unique index that is defined as WHERE NOT NULL | VARCHAR(128) | VARCHAR(128) | NA |
IXWC | Unique and clustering index that is defined as WHERE NOT NULL | VARCHAR(128) | VARCHAR(128) | NA |
MK | Column mask | VARCHAR(128) | VARCHAR(128) | NA |
RP | Row permission | VARCHAR(128) | VARCHAR(128) | NA |
SG | Storage group (stogroup) | VARCHAR(128) | NA | NA |
SP | Stored procedure | VARCHAR(128) | VARCHAR(128) | NA |
SPE | External stored procedure | VARCHAR(128) | VARCHAR(128) | NA |
SPN | Native SQL stored procedure | VARCHAR(128) | VARCHAR(128) | VARCHAR(64) |
SPNA | Active version of native SQL stored procedure | VARCHAR(128) | VARCHAR(128) | VARCHAR(64) |
SPS | External SQL stored procedure | VARCHAR(128) | VARCHAR(128) | NA |
SQ | Sequence | VARCHAR(128) | VARCHAR(128) | NA |
SY | Synonym | VARCHAR(128) 2 | VARCHAR(128) | NA |
TB | Table Application-period temporal table Auxiliary table Bitemporal table System-period temporal table XML table | VARCHAR(128) | VARCHAR(128) | NA |
TBH | Table that Db2 uses to store historical versions of rows from the associated system-period temporal table (history table) | VARCHAR(128) | VARCHAR(128) | NA |
TBB | Table containing a large object (LOB) or an XML column (base table) | VARCHAR(128) | VARCHAR(128) | NA |
TBBH | Base table that uses system-period data versioning | VARCHAR(128) | VARCHAR(128) | NA |
TBBT | Base table that uses table-controlled partitioning | VARCHAR(128) | VARCHAR(128) | NA |
TBC | Clone table | VARCHAR(128) | VARCHAR(128) | NA |
TBGT | Global temporary table | VARCHAR(128) | VARCHAR(128) | NA |
TBQ | Materialized query table (MQT) | VARCHAR(128) | VARCHAR(128) | NA |
TBQT | Materialized query table (MQT) that uses table-controlled partitioning | VARCHAR(128) | VARCHAR(128) | NA |
TBR TBBR | Archive table Archive table for table containing a large object (LOB) or an XML column (base table) | VARCHAR(128) | VARCHAR(128) | NA |
TBT | Table that uses table-controlled partitioning | VARCHAR(128) | VARCHAR(128) | NA |
TR | Trigger in which the trigger text references the table | VARCHAR(128) | VARCHAR(128) | NA |
TRA | Active advanced trigger | VARCHAR(128) | VARCHAR(128) | VARCHAR(64) |
TRAB | Active advanced trigger that references the table | VARCHAR(128) | VARCHAR(128) | VARCHAR(64) |
TRB | Trigger that references the table | VARCHAR(128) | VARCHAR(128) | NA |
TS | Table space Auxiliary table space XML table space The TS might have any of the following characteristics:
| VARCHAR(24) 1 | VARCHAR(24) 3 | NA |
TSA | Orphaned auxiliary table space | VARCHAR(24) 1 | VARCHAR(24) 3 | NA |
TSG | Partition-by-growth table space | VARCHAR(24) 1 | VARCHAR(24) 3 | NA |
TSI | Partitioned table space that contains a table that uses index-controlled partitioning A TSI can be any TS that is LIKEd from a TSI or any TS that is converted to index-controlled partitioning. | VARCHAR(24) 1 | VARCHAR(24) 3 | NA |
TST | Partitioned table space that contains a table that uses table-controlled partitioning A TST can be any TS that is LIKEd from a TST or any TS that is converted to table-controlled partitioning. | VARCHAR(24) 1 | VARCHAR(24) 3 | NA |
TSR | A range-partitioned table space | VARCHAR(24) 1 | VARCHAR(24) 3 | NA |
TSR2 | Partition-by-range table space with relative page numbering | VARCHAR((24) 1 | VARCHAR(24) 1 | NA |
UC | Unique constraint | VARCHAR(128) | VARCHAR(128) | VARCHAR(128) |
UCP | Primary key constraint | VARCHAR(128) | VARCHAR(128) | VARCHAR(128) |
UCU | Unique (nonprimary) key constraint | VARCHAR(128) | VARCHAR(128) | VARCHAR(128) |
VW | View | VARCHAR(128) | VARCHAR(128) | NA |
1 In a Unicode subsystem, the database name can be defined as VARCHAR(24). However, in a non-Unicode subsystem, the name can be defined only as VARCHAR(8).
2 The synonym owner is limited to a maximum of 8 bytes.
3 In a Unicode subsystem, the table space name can be defined as VARCHAR(24). However, in a non-Unicode subsystem, the name can be defined only as VARCHAR(8).