What is the code for adding a foreign key to a table, just a simple foreign
key from one table to another?

Creating one table is simple enough, but then when you create the second
table with a foreign key to the first, can you specify that a field is a
foreign key at the time you create the second table?

Or do you need to use an ALTER TABLE statement to add the foreign key?

Thanks,
Stephen