What's the difference between 'collision' and 'conflict'? In SQL language, should I say 'PK collision' or 'PK conflict'?
Learn English – What’s the difference between ‘collision’ and ‘conflict’
differencesnouns
Related Topic
- Learn English – What’s the difference between ‘china’ and ‘porcelain’
- Learn English – What’s the difference between “onto” and “on to”
- Learn English – What’s the difference between “big” and “large”
- Learn English – What’s the difference between “rigor” and “rigorousness”
- Learn English – What’s the difference between “trust” and “believe”
Best Answer
A collision is usually taken to mean a physical impact: two cars which crash into each other would be a collision.
A conflict is normally between two or more things which disagree in some way, although its meaning can be extended across both tangible and intangible notions. For instance, you can have a conflict of opinions, where someone disagrees with the other, but you can also have a physical conflict (a fight, or a war).
Conflict, used in its physical sense, could be synonymous with collision.
In your case, you should say a Primary Key (PK) Conflict, as — and I'm assuming it's a duplicate here — the primary keys disagree with each other because they are the same.
They don't physically bump into each other.