what are the advantages of primary key over unique+notnull

Answer Posted / charumathi

Unique-Duplicates not allowed
Nulls allowed
Not null-NUlls not allowed
Primary key-No Duplicates
No Nulls
A Foriegn key can refer to the primary key.

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does varchar need length?

516


How much ram can sql express use?

505


What is full join in sql?

518


How many commands are there in sql?

545


what are the t string functions available in tsql? : Transact sql

540






What are the two types of periodical indexes?

503


How do I save a stored procedure?

520


What is %s in sql?

562


What is a sql select statement?

562


What is primary key in db?

517


What is the difference between row level and statement level trigger?

517


Why triggers are used?

553


What is the life of an sql statement?

523


Is sql a programming?

545


What are its different types of dbms?

536