Creating a Test Table with Data - Teradata Vantage

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

1. Log on as Alex using secret as the password.
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');