This is an example of SHOW TABLE output for the following table definition which includes a derived period column.
CREATE TABLE employee ( eid INTEGER NOT NULL, name VARCHAR(100) NOT NULL, deptno INTEGER NOT NULL, jobstart DATE NOT NULL, jobend DATE NOT NULL, PERIOD FOR jobduration (jobstart, jobend) ) PRIMARY INDEX(eid);
Below is the SHOW TABLE output.
CREATE SET TABLE TEST.employee ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO MAP = TD_MAP1 ( eid INTEGER NOT NULL, name VARCHAR(100) NOT NULL, deptno INTEGER NOT NULL, jobstart DATE NOT NULL, jobend DATE NOT NULL, PERIOD FOR jobduration (jobstart, jobend) ) PRIMARY INDEX(eid);