What are different table types used in Teradata?

1.	What are different table types used in Teradata?
Answer» There have FOUR table types SUPPORTED in Teradata: Permanent Table: It’s the default table and contains data put by the USER and stores that data permanently. Global Temporary Table: Persistent but the data present in the table will be deleted at the end of the user session. Volatile Table: The data into this table is retained only during the user session. Derived Table: It holds the intermediate results in a query. The lifetime of this table depends on the query in which they are CREATED, dropped and used. This is a fundamental question in teradata interview questions.

Answer»

There have FOUR table types SUPPORTED in Teradata:

Permanent Table: It’s the default table and contains data put by the USER and stores that data permanently.
Global Temporary Table: Persistent but the data present in the table will be deleted at the end of the user session.
Volatile Table: The data into this table is retained only during the user session.
Derived Table: It holds the intermediate results in a query. The lifetime of this table depends on the query in which they are CREATED, dropped and used.

This is a fundamental question in teradata interview questions.

Discussion