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

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Published
January 2021
Language
English (United States)
Last Update
2021-05-08
dita:mapPath
gta1588198788318.ditamap
dita:ditavalPath
dby1605127568110.ditaval
dita:id
B700-4014
Product Category
Analytical Ecosystem
Software
Teradata Vantage

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');