Both r same :) Primary Key= (Unique + Not Null)

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 / banti

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

Answer Posted / banti

Both r same :)
Primary Key= (Unique + Not Null)

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to create a table index in mysql? : Sql dba

986

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3945

How do you declare a constant?

910

Why do we use joins in sql?

908

What is the difference between function and procedure in pl/sql?

1014

What are tables in sql?

997

How do you update a sql procedure?

971

How do I get sql certification?

924

What is a table?

956

Can we connect to postgresql using sql developer?

935

How does join work in sql?

957

What is dcl in sql?

904

what is msql? : Sql dba

940

What is pl/sql table? Why is it used?

977

what are aggregate and scalar functions? : Sql dba

993