English Language & Usage Stack Exchange is a question and answer site for linguists, etymologists, and serious English language enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What's the difference between 'collision' and 'conflict'? In SQL language, should I say 'PK collision' or 'PK conflict'?

share|improve this question
are you interested in the English definitions, or only the usage w.r.t. SQL and computer science? – JoseK Feb 25 '11 at 10:49
up vote 4 down vote accepted

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.

share|improve this answer
Actually I might add that collision can be somewhat metaphorical as well, in that a collision of ideas would, at least to my ears, imply that the ideas expressed were in greater opposition and that each side might argue their side more vehemently than in a mere conflict. – Andy F Feb 25 '11 at 11:00

For the First Question - Conflict

And for the second question you should call it as Primary Key Conflict.

share|improve this answer
I disagree, with the second - PK/FK are not only universally understood, but arguably they are expected - I can only assume he is addressing a technical audience. – CJM Feb 25 '11 at 12:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.