Answer Detail: RE: What is difference between UNIQUE and PRIMARY KEY ...

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 09:43:01	#1
Vijay Raj Jaiswal	Member Since: Visitor Total Comments: N/A
RE: What is difference between UNIQUE and PRIMARY KEY ...
Hi this is modified answer ,pls post this instead of previous which i post Primay Key Unique key ----------- ------------------ There is only one there may be more than 1 Primary key for Unique Key in table 1 table It can not contain It Can contain Null Value Null value

Back To Question