Foreign Keys

Howdy folks,

I am hoping someone can clarify something for me. If I create a foreign key constraint on a table:

ALTER TABLE bingo ADD constraint for_key_bingo FOREIGN KEY (col1, col2)
REFERENCES yikes (col1,col2);

and then add a new row to bingo, the col1/col2 attribute values have to exist in yikes. I am curious what other uses folks have for foreign keys?

Thanks for any insight,
Ryan Received on Sun Jan 05 2003 - 15:40:56 CST