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
10528 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 create an index in word?

1035

What is java sql driver?

1129

what is cross join? : Sql dba

1004

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2226

what are the disadvantages of mysql? : Sql dba

1149

what is blob? : Sql dba

1154

what are tables and fields? : Sql dba

1060

What is sql data?

998

How do I add a primary key to a table?

1042

Describe sql comments?

1046

What is the difference between rollback and rollback to statements?

1061

What programs use sql?

1014

Are there any features that are decommissioned in 11g that are not present in 11g?

2150

What is the use of primary key?

1008

What are character functions?

1091