Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Wednesday, 13 August 2014

Types of tables in Teradata

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

Please provide your feedback in the comments section above. Please don't forget to follow.