Database Object Types - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Database Object Types

Table 22 gives a brief description of different database object types.

 

Table 22: Database Object Types 

Object Type

Object

Description

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

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.

Globally Persistent Object (GLOP)

GLOP

Theses 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.