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

what are null values? : Sql dba

937

What is set transaction?

1018

How to take user input in pl sql?

1145

What is the difference between execution of triggers and stored procedures?

1098

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

2207

Can we create index on primary key?

949

How do I run a script in sql developer?

933

What is difference between rank () row_number () and dense_rank () in sql?

1089

What is sql key?

965

Can we enter data in a table in design view?

949

Can a varchar be a primary key?

989

What is the reports view in oracle sql developer?

952

What is the difference between nested table and varray?

992

what is clause? : Sql dba

1050

What is t-sql? : Transact sql

966