alter table tableName drop constraint pk_name; alter table tableName add constraint primary key(id) constraint pk_name;