Example: Creating an ANSI Valid-Time Table - Advanced SQL Engine - Teradata Database

The following example creates a valid-time table.

CREATE MULTISET TABLE employee_valid_time (
 eid INTEGER NOT NULL,
 ename VARCHAR(5) NOT NULL,
 terms VARCHAR(5),
 job_start DATE NOT NULL,
 job_end DATE NOT NULL,
 PERIOD FOR job_dur(job_start,job_end) AS VALIDTIME
 )
 PRIMARY INDEX (eid);