Creating a Foreign Key |
|
A foreign key is used to refer to another table by specifying the referencing and referenced columns. Both the referencing and referenced columns should be mapped to each other. The mapping columns should be the same type and length. The referenced columns should be NOT NULL, but the referencing columns can be NULL .The referenced columns should be a primary key or unique index.
Related topic:
Using
Foreign Keys
Adding a Foreign Key
Setting Foreign Key Options