Mar
15

Foreign Key Reference more than 1 table


create table address(addr_No int not null, cust_no int not null, emp_no int not null, blah, blah, primary key(addr_No),
index(cust_No), index(emp_No),
Foreign Key(cust_No) references customer(cust_No),
Foreign Key(emp_No) references employee(emp_No));

Source : http://www.dbforums.com/ansi-sql/983522-foreign-key-referencing-more-than-1-table.html


by admin on March 15th, 2009 in Database

There are no comments.

Name*: Website: E-Mail*:
XHTML: You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>