Teradata Objects

Hi,

• There are eight types of objects which may be found in a Teradata database/user.

           ----> Tables – rows and columns of data 
           ----> Views – predefined subsets of existing tables
           ----> Macros – predefined, stored SQL statements
           ----> Triggers – SQL statements associated with a table
           ----> Stored Procedures – program stored within Teradata
           ----> Join and Hash Indexes – separate index structures stored as objects within a database
           ----> Permanent Journals – table used to store before and/or after images for recovery

• These objects are created, maintained and deleted using Structured Query Language (SQL).
•  Object definitions are stored in the Data Dictionary / Directory (DD/D).