Btrieve - Can Unique key be used as Foreign Key?

GeekInterview.com > Interview Questions > Database > Btrieve

Go To First | Previous Question |

Btrieve | Question 11 of 11

Can Unique key be used as Foreign Key?

can unique key be used as foreign key? What is the difference between Primary key and unique key?

Total Answers and Comments: 4

Last Update: March 12, 2009 Asked by: Rehan Naqvi

Sponsored Links

Best Rated Answer

—

Submitted by: amitabhmishra

ya why not............

even primary can be foreign key

Above answer was rated as good by the following members:
tandel jack

June 12, 2008 09:13:17

dv3315

Member Since: June 2008 Contribution: 1

RE: Can Unique key be used as Foreign Key?

I think it can't.Because Foreigh Key maybe duplicated.

Is this answer useful? Yes | No

June 13, 2008 04:38:43

amitabhmishra

Member Since: June 2008 Contribution: 1

RE: Can Unique key be used as Foreign Key?

ya why not............

even primary can be foreign key

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 16, 2009 06:01:09

ajaymca.039

Member Since: January 2009 Contribution: 1

RE: Can Unique key be used as Foreign Key?

I think no because unique key may not be duplicate but foreign key may be duplicated in some cases.

Is this answer useful? Yes | No

March 12, 2009 02:23:57

himanshu D silva

Member Since: March 2009 Contribution: 2

RE: Can Unique key be used as Foreign Key?

No as unique allow only one null in a column and there cannot be any duplicate data can be inserted in that column which is associated with unique key and on the other hand foreign key allow the duplicate key.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank