The following table gives a brief description of different database object types.
| Object Type | Object | Description |
|---|---|---|
| Function Alias | Function Alias | These objects do not have data, therefore only dictionary information is processed. |
| Globally Persistent Object (GLOP) | GLOP | Theses objects do not have data, therefore only dictionary information is processed. |
| Indexes | Join Index | Theses objects do not have data, therefore only dictionary information is processed. |
| Hash Index | ||
| Macro | Macro | Theses objects do not have data, therefore only dictionary information is processed. |
| Procedures | Stored Procedure | These objects have data, therefore dictionary and data information is processed. |
| External Stored Procedure | ||
| Java JAR Stored Procedures | ||
| Schema | Schema | These objects do not have data, therefore only dictionary information is processed. |
| Server | Remote Server | Theses objects do not have data, therefore only dictionary information is processed. |
| Tables | Journal Table | These objects have data, therefore dictionary and data information is processed. Tables can be specified as individual objects with any version of the Teradata Database. |
| Partitioned Primary Index (PPI) Table | ||
| Table | ||
| No Primary Index (NO-PPI) Table | ||
| Triggers | Trigger | Theses objects do not have data, therefore only dictionary information is processed. |
| User Defined Functions (UDF) | Aggregate UDF | These objects may have data depending on their usage, therefore the information is processed accordingly. |
| Scalar UDF | ||
| Statistical UDF | ||
| Table UDF | ||
| Combined Aggregate and Statistical UDF | ||
| Table Function(Operator) | ||
| Parser Contract Function | ||
| UDF Authorization | Theses objects do not have data, therefore only dictionary information is processed. | |
| User Defined Methods (UDM) | UDM | These objects may have data depending on their usage, therefore the information is processed accordingly. |
| User Defined Types (UDT) | UDT | Theses objects do not have data, therefore only dictionary information is processed. |
| User Installed Objects (UIF) | UIF | These objects have data, therefore dictionary and data information is processed. |
| Views | View | Theses objects do not have data, therefore only dictionary information is processed. |