sql - Creating Primary Keys on the Table -

we have list of tables in our database no primary key defined. have decided add primary key on it. of tables have identity key column. in of stored procedures, used other columns data retrieval. confused in column need create primary key since create clustered index also.

thanks help.

you can try following example;

alter table db.tablename  add constraint pk_id primary key nonclustered (id);