Mark as Answer it this helps:
Short answer as much as possible.
One table can have as much as possible foreign keys , but recommended not to have more than 253 FK in a table as recommended by BOL.
Create table masterproduct (productid int primary key , productdescription varchar(50))
Create table mastersubprocuct (productsubid int primary key , productdescription varchar(50))
create table saledata (productid int FOREIGN KEY REFERENCES masterproduct(productid)
,productsubid int FOREIGN KEY REFERENCES mastersubprocuct(productsubid)
, saleqty int )
drop table masterproduct
drop table mastersubprocuct
drop table saledata
Visit my blog www.tutorialsqlserver.com
Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator