There are different types of tables available in Teradata. Let's look at those:-
Table
Name
|
Description
|
Global Temporary Table
|
When
session log out data gets vanished DDL persist.
|
Volatile
tables
|
When
session log out data and table gets vanished.
|
Set
tables
|
Permanent
table. Strictly don’t allows duplicate values
|
Multiset
tables
|
Permanent
table. Allows duplicate values
|
Derived
tables
|
Stores
data fetch from the query on run time.
|
Read Also:- Create table in Mysql
No comments:
Post a Comment