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?
What are the rights needed by the user in order to open a btrieve file in accelerated mode?
What is the use of the option brebuild in btrieve?
What are the possible reasons for getting file locked error in btrieve?
What are the features and advantages of btrieve?
How is indexes created using btrieve and is it possible to create supplemental index using btrieve?
What is the way of finding the version of btrieve being used?
What happens when btrieve files are made as sharable to netware?
What are the steps or process for running a btrieve application with pervasive SQL?
What is the meaning of btrieve returning a status 22 and how to overcome this?
Answer is Yes. You can find details here http://msdn.microsoft.com/en-us/library/ms175464(v=SQL.90).aspx
Yes use it if we implement one to one relationship b/w table the foreign key is unique.