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
10439 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

what is the difference between undefined value and null value? : Sql dba

1089

How do sql triggers work?

1030

How does one use sql*loader to load images, sound clips and documents? : aql loader

1172

What are the operators in sql?

1012

Can we join two tables without common column?

993

How do you create an update query?

955

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

996

how to drop an existing view in mysql? : Sql dba

1049

What is difference between primary and secondary key?

1017

How to select random rows from a table?

1065

What is a sql instance vs database?

1107

Can we insert in view in sql?

1042

What is normalization? How many normalization forms are there?

1078

What is the difference between truncate and drop statements?

1171

What is normalization in sql?

1004