Permanent Table - Once created, remains in the database until it is dropped. It can be shared with different sessions and users. 1. SET table - Strictly NO duplicate values [By-Default] 2. MULTISET table - Allows Duplicate Values.
1.Volatile Table - Only the session in which it is created can access the table structure and data. Session ends, table gets dropped. 2.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. NoPI Table - Permanent tables that do not have any primary index defined on them.