Skip to main content Skip to complementary content

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 – please let us know!