ANSWER:
A:
When the table is created. Like all other constraints, the FOREIGN KEY constraint is created with the same script that creates the table.
Answers in Depth...