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
10721 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 are stored procedures in mysql?

1069

How do I save a stored procedure?

1064

Can primary key be changed?

950

What are sql queries used for?

1070

What is user defined functions?

1028

What are packages in pl sql and also explain its advantages?

1119

Is pl sql still used?

1016

What is sql keyword?

1043

What is the syntax and use of the coalesce function?

1209

what are the 'mysql' command line arguments? : Sql dba

1185

what are the differences between char and varchar? : Sql dba

1111

Which command is used to delete a package?

1230

Why do we use joins?

1097

What is the starting oracle error number? What is meant by forward declaration in functions?

1039

How to make a copy values from one column to another in sql?

1077