Create Test Table with Data | Teradata Vantage - 2.2 - Creating a Test Table with Data - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)

Log on as the temporary user, Alex, to create a test table and insert rows.

  1. Log on as Alex.
  2. Set the default database for the session to Tables_Database. For example:
    DATABASE Tables_Database;
  3. Create a table named employee with emp_id, emp_name, and start_date columns. For example:
    CREATE SET TABLE employee (
    emp_id INTEGER,
    emp_name CHARACTER(20) CHARACTER SET LATIN NOT CASESPECIFIC,
    start_date DATE)
    PRIMARY INDEX (emp_id);
  4. Insert rows of data into the table. For example:
    INSERT INTO employee (emp_id, emp_name, start_date)
    VALUES (1001, 'Mary', '2010-01-10');
    INSERT INTO employee (emp_id, emp_name, start_date)
    VALUES (1002, 'Sam', '2014-07-01');
    INSERT INTO employee (emp_id, emp_name, start_date)
    VALUES (1003, 'Charles', '2016-02-10');