The following table types exists in Teradata:
- Permanent Table - Once created, remains in the database until it is dropped. It can be shared with different sessions and users.
- Volatile Table - Only the session in which it is created can access the table structure and data. Session ends, table gets dropped.
- Global Temporary Table - Once created, the structure can be shared with different sessions and users but the data remains private to the session who loaded it. Session ends, its private data gets deleted.
- Derived Table - A type of temporary table derived from one or more other tables as the result of a sub-query.
- Queue Table - Permanent tables with timestamp column which indicates when each row was inserted.
- Error Logging Table - Stores errors of an associated permanent table.
- Global Temporary Trace Table - Stores trace output for a particular session duration.
- NoPI Table - Permanent tables that do not have any primary index defined on them.
