Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table?

Answer Posted / gaurav gautr

yes it is possible but your data fetch speed will slow down

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why I can not enter 0.001 second in date and time literals in ms sql server?

631


Explain how dts is used to extract, transform and consolidate data?

669


What is the data type of time?

604


How can a user-defined datatype be created?

639


Does group by sort data?

594






What is a join in sql?

657


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

606


What does Master database contains?

711


how to determine the service pack currently installed on sql server? : Sql server database administration

649


what is the main function of a query parameter?

115


How to compare the top two records using sql?

860


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

737


What are the elements of dbms?

629


What triggers long term care?

639


What is store procedure?

752