Creating foreign keys

Foreign keys describe relationship between tables. For example, orders table will usually have an entry saying which customer made an order. Database will refuse to add data that breaks the foreign key definition - you won't be able to insert a row specifying a non-existent customer, for example.

Foreign keys require indexes to be in place, as database needs to quickly locate related record to check that data is valid.