To alter a Primary/foreign/unique column in a table without dropping the constraints in the table.

ie, what might be option available to rename/insert values into, a primary column in a table without dropping the primary constraint. ...