Database Developer Question:
Tell us what is the difference between UNIQUE and PRIMARY KEY constraints?
Answer:
There should be only one PRIMARY KEY in a table whereas there can be any number of UNIQUE Keys.
PRIMARY KEY doesn’t allow NULL values whereas Unique key allows NULL values.
PRIMARY KEY doesn’t allow NULL values whereas Unique key allows NULL values.
| Previous Question | Next Question |
| Explain me what are SQL constraints? | Tell us what is a DEFAULT constraint? |