Toad World® Forums

Domain with default value on parent key is cascaded

When create a foreign key, if the parent column is using Domain to define its data type and default value, then the domain will be assigned to the column in the child table. The problem is if the column in the parent table has nextval of a sequence as its default value, then the column in the child will have this nextval as its default. Which should never happen in any real world. How do I remove the default value from the child table?

Unfortunately this is not possible. Domain are not suitable for foreign attributes from this reasons.

Petr