But if the primary key is referenced by foreign keys and has an index, constraints are lost by dropping it.