|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/28/2009 10:08:50 AM
Posts: 6,
Visits: 46
|
|
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
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
First drop that table/view where it's referenced.
Drop the child table - then Parent table...
|
|
|
|