ensure that the indexed column is not an FK before deleting the index