Teradata Cookbook

Creating, copying, and dropping tables

Teradata Database uses tables to store data in rows. Tables consist of rows and columns in a database, and can be seen in the following figure:

In Teradata, you can create the following types of tables:

• Permanent Table: Remains in the database until dropped manually:
  • SET
  • MULTISET 
• Temporary Table: Session based:
  • Derive table
  • Volatile table
  • Global temporary table
  • Queue table
  • Error logging table
  • NOPI table

In this recipe, we will create, drop, and copy data from one table to another.