Want to use a unique constraint on a virtual column and use a foreign constraint on this column.
The column used should keep a NULL able type.
Choose a Unique constraint in the attribute, causes also the enabling of the Not Null constraint.
Is it possible to define a unique constraint and uses this in the foreign key constraint, but without to enable the Not Null constraint in TDM?
Technical it is possible to do for example:
ALTER TABLE table_with_unique_constraint
ADD CONSTRAINT SREF_DOELEN_UK
ALTER TABLE table_with_refto
ADD CONSTRAINT “table_refto_twuc” FOREIGN KEY (DOELEN) REFERENCES table_with_unique_constraint (DOELEN_FK) ON DELETE SET NULL
/ Message was edited by: firstname.lastname@example.org
Message was edited by: vladka