Skip to main content Skip to complementary content
Announcements

Creating a new Teradata database table

Procedure

  1. Double-click tTeradataRow to open its Basic settings view.
  2. Fill in the Host, Database, Username, and Password fields with your Teradata database connection details.
  3. In the Query field, enter the following SQL statement to create a new table named person with three columns id, name, sex. 
    CREATE SET TABLE samples.person,
FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL
(
  id INTEGER NOT NULL,
  name VARCHAR(50),
  sex VARCHAR(20)
)
UNIQUE PRIMARY INDEX (id)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here