what is the difference between unique and primary key
Answers were Sorted based on User's Feedback
Answer / ravi kanth
Primary key is the combination of unique and not null.But
unique key accepts null values also.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / suresh kumar somayajula
Unique Key allows NULL value and a table can have more than
one UNIQUE KEY Constraint.
Primary Key is the combination of UNIQUE+NOT NULL,means it
won't allow NULL Values and a table can have only one
Primary Key.But a table can have Composite Primary Key.
Thank you,
Suresh
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / priyanka
Both are uniqe identification keys but Primary key should
not be null but uniqe key should.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / divyarao
primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vinod
uniqe key allow one null value only but primary key cannot
allow any null value
Is This Answer Correct ? | 0 Yes | 1 No |
How does a database partition work?
I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........
What are the benefits of database?
What is meant by database management system?
What is data example?
Why its better to use files than a DBMS when there are multiple users to access the data
What restrictions can you apply when you are creating views?
Explain the term entity set in dbms?
What are the different events in Triggers ?
What is rdbms and also explain its components?
What is dbms introduction?
where a Database Procedure is stored ?