How Many Types Of Tables Exist And What Are They In Data Dictionary?

1.	How Many Types Of Tables Exist And What Are They In Data Dictionary?
Answer» 4 Types of Tables: Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Open SQL and Native SQL can be used. Pool tables - Pooled tables in the dictionary has a many-to-ONE relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level. Cluster tables - These are logical tables that are arranged as records of transparent tables. One cannot use Native SQL on these tables (only Open SQL). They are not manageable DIRECTLY using database system tools. Internal tables - Internal table is a temporary table stored in the RAM of the application server. It gets CREATED during the program execution and gets DELETED once the program ends. 4 Types of Tables:

Answer»

4 Types of Tables:

Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Open SQL and Native SQL can be used.
Pool tables - Pooled tables in the dictionary has a many-to-ONE relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.
Cluster tables - These are logical tables that are arranged as records of transparent tables. One cannot use Native SQL on these tables (only Open SQL). They are not manageable DIRECTLY using database system tools.
Internal tables - Internal table is a temporary table stored in the RAM of the application server. It gets CREATED during the program execution and gets DELETED once the program ends.

4 Types of Tables:

Discussion