What are advantage of having primary key
spur230Apr 20 2012 — edited Apr 20 2012I have a error logging table without a primary key. It does not have any candidate key. If we decide to add a primary key, I would need addition column to create surragate key based primary key.
In what conditions is it ok not to have primary key?
I know primary key is needed to uniquely identify records, for scalablity to have foreign key constraint, index. Apart from these, what are other compelling reasons to have primary key in a table ?
Thank you for your time.