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
10512 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 is the plv (pl/vision) package offers?

1052

Is mariadb a nosql database?

1055

Which table is left in join?

978

Why do we need cursor in pl sql?

1133

How do you select unique values in sql?

997

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

What is prepared statement in sql?

1049

What is the difference between numeric and autonumber?

997

What is benefit of creating memory optimized table?

972

How many types of triggers exist in pl/sql?

1072

how many columns can be used for creating index? : Sql dba

946

What are triggers and its types?

1062

What is the primary use of normalization?

1004

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

What is sharding in sql?

984