Walter Meester
HoogkarspelNetherlands
General information
Forum:
Microsoft SQL Server
>>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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only