Example: SHOW TABLE with Column-Level Named Constraints - Advanced SQL Engine - Teradata Database

The request in this example names constraints at the column level.

     CREATE TABLE good_1 (        column_1 INTEGER NOT NULL CONSTRAINT primary_1 PRIMARY KEY,         column_2 INTEGER NOT NULL CONSTRAINT unique_1 UNIQUE,         column_3 INTEGER CONSTRAINT check_1 CHECK (column_3 > 0),        column_4 INTEGER CONSTRAINT reference_1 REFERENCES parent_1);

Now perform the following SHOW TABLE request on good_1.

     SHOW TABLE good_1;

The request returns the following CREATE TABLE SQL text.

     CREATE SET TABLE personnel.good_1, NO FALLBACK,         NO BEFORE JOURNAL, NO AFTER JOURNAL (         column_1 INTEGER NOT NULL,         column_2 INTEGER NOT NULL,         column_3 INTEGER,         column_4 INTEGER,         CONSTRAINT check_1 CHECK ( column_3 > 0 ),         CONSTRAINT reference_1 FOREIGN KEY ( column_4 )            REFERENCES personnel.parent_1 ( f2 ))      UNIQUE PRIMARY INDEX primary_1 ( column_1 )      UNIQUE INDEX unique_1 ( column_2 );