Unanswered: Delete rows with FK to lookup table in Teradata
Hello everyone, I'm trying to delete rows of a table which has foreign keys to a lookup values table. The FK's are setted as restricted.
When I try to delete the 'Referential constraint violation: cannot update/delete the Parent key value' msg appear.
One aproach I saw is to drop the reference FK, delete and then add it again, but I think may be there is a better way.
I'm working in Teradata.