>>>Of course the table has a primary key; all tables of my SQL server database have primary keys. Thank you for clarifying your point.
>>
>>You'd be surprised how many people don't have primary key definitions (and/or don't even have a candidate definition for a primary key)
>
>I have several log tables which do not have a PK. Just because of the overhead (of very long logs) it was deliberately stripped out.
>
>But in any other case, I agree table in which are involved in RI and update and deletes happen should have a single PK field
>
>Walter,
I don't have any links to back this up, but some time ago I remember reading/hearing that certain IT audits actually required PK fields on all tables, even history audit trail logs.
True, the main focus should be on transactional/operational tables - though admittedly I add a single PK field on every table.