16.10 - ObjectType Column Values - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)
Value Description
Agg User-defined aggregate function
AgS User-defined aggregate STAT function
Aut Security authorization
Col Column
DB Database
HIx Hash index
Idx Index. For each index, there is a database name, table name, and column name. The ObjectId column is the identifier of the table and the ObjectNum column is the number of the index in that table. For multi-column indexes, there is one row for each column of the index that a query used. For example, if an index consists of three columns and the query uses all three, there will be three rows, each with a different column name. The column name will be null for an index for statements such as COLLECT STATISTICS, ALTER PROCEDURE, SHOW PROCEDURE, or SELECT COUNT(*).
JIx Join index. For each join index, there is a database name and join index name in the ObjectTableName field. For these rows, the ColumnName indicates a column referred to by the join index.
  • ObjectType is ‘JIx.’
  • ObjectId matches the ID of the join index.
  • ObjectNum is 0.
Jrl Journal
Mac Macro
NoT No type (unknown)
SP Stored procedure
Sta User-defined STAT function
Tab Table
TbF Table function
Tmp Temporary
TbO Table operator
TbC Contract function
Trg Trigger
UDF User-defined function
UDM User-defined method
UDT User-defined type
Viw View
Vol Volatile
XSP External stored procedure