can not drop table stay lock

Tools
Teradata Employee

can not drop table stay lock

I am in Teradata V2R6

I can not drop table stay lock because in fact there is a reference constraint between the table and remained lock another table.

- When I try to drop a lock table I get the message "I can not drop the table because it is referenced by another table.

- When I try to delete the reference constraint in the other table I get the message "this constraint can not be droped because it references an lock table.

Have you an idea how to force the drop this table
1 REPLY
Enthusiast

Re: can not drop table stay lock

First drop that table/view where it's referenced.
Drop the child table - then Parent table...