I have a table A which has an FK constraint referencing another table B.
Dropping this FK constraint on A locks table B, as does trying to drop
table A. Why is this?
Is there some more efficient way to remove FK constraints without locking
the referenced table?
Thanks for clarification.
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>