| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: What is difference between UNIQUE and PRIMARY KEY constraints?
Answer:
A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL. |
| September 09, 2005 06:09:45 |
#2 |
| kalai |
Member Since: Visitor Total Comments: N/A |
RE: What is difference between UNIQUE and PRIMARY KEY ...
|
| Primary key creates clustered index whereas unique key creates non clustered index.primary key won't allow NULL values whereas unique key allows NULL values. |
| |
Back To Question | |
