the above answer is wrong ...we can use foreign key for unique key also..

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

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

Answer Posted / shahid

the above answer is wrong ...we can use foreign key for
unique key also...

Is This Answer Correct ?

8 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the two characteristics of a primary key?

958

How do I know if I have sql express or standard?

1013

How many times can we commit in a loop?

998

What are all types of user defined functions?

1055

What is the basic form of sql query?

922

Are sql connections encrypted?

998

How do I partition a table in sql?

1100

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2481

Explain the advantages and disadvantages of stored procedure?

1129

Which sql most popular?

974

Name some usages of database trigger?

1004

What is varchar sql?

1116

What is optimistic concurrency control? : Transact sql

969

Which one is better subquery or joins?

1039

how to convert numeric values to character strings? : Sql dba

1082