Enforce row count in a table

Database
Teradata Employee

Enforce row count in a table

Hi all

I have a table like BUSINESS_DATE_TBL which has 2 column of 1 date type and other varchar( this is one i use to create parameter).

my complete production load is dependent on this table as date in this table ensures for which day load will be triggered.

Is there any way in teradata at DDL to enforce that no other row can be inserted in this table if 1 row already exist.

Thanks in advance.

Tags (1)
1 REPLY
Senior Apprentice

Re: Enforce row count in a table

You could use a trigger or add a dummy column:

col NOT NULL UNIQUE DEFAULT 1 CHECK (col = 1)