sql server - Adding a new primary key to existing table -
i have table following details
table name employee
, columns
empid (pk smallint not null) empname (varchar 256 not null) org (fk smallint not null) function (fk smallint not null) eff_date (datetime null) audit_id (varchar null)
now have add coulmn table add_uid
, make primary key
i using query failing.
alter table cvadmin.employee add add_uid varchar(32) null, constraint pk_employee primary key [non]clustered (add_uid) go
table 'employee
' has primary key defined on it.
edit
the idea here new column should unique if fails can throw _key_violation code manipulation done
to add unique constraint (which additional primary key) this:
alter table employee add constraint uc_uid unique (add_uid)
Comments
Post a Comment