if it is Primary key then we can make use foreign key in other table and ca

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????

Question Posted / gazulas

8 Answers
10375 Views
rsystems, I also Faced
E-Mail Answers

Answer Posted / gazulas

if it is Primary key then we can make use foreign key in other table and can use the referential integrity concept

for unique keys we dont have that.

Is This Answer Correct ?

4 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I order by ascending in sql?

989

Explain what is an index?

1034

Does sql*plus have a pl/sql engine?

1048

Can there be more than one function with a similar name in a pl/sql block?

968

how to select unique records from a table? : Sql dba

1090

Is it possible to create startup or shutdown trigger for on-schema?

1009

How do I upgrade sql?

986

What are the two types of cursors in pl sql?

1056

What is cursor and why it is required?

1162

What is the use of <> sql?

959

How can we link a sql database to an existing android app?

1013

what are the disadvantages of mysql? : Sql dba

1129

Why left join is used in sql?

956

What problem one might face while writing log information to a data-base table in pl/sql?

1133

What is the difference between partitioning and sharding?

989