| Agg |
User-defined aggregate function |
| AgS |
User-defined aggregate STAT function |
| Aut |
Security authorization |
| Col |
Column |
| DB |
Database |
| GLP |
GLOP set |
| 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 |