Drop foreign key locks referenced table
ALTER TABLE x drop constraint fk12345; take long time because the parent table (user) in transaction(delete,insert update,..) or X table itself in transaction(not commit or rollback), it meant ALTER TABLE x drop constraint fk12345 may not make the User table locked.