Walter Meester
HoogkarspelPays-Bas
Information générale
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,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement