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?