There are 2 ways:
1. Primary Key named as "ID", Foreign Key as "ProductID" for example.
2. Primary Key named as "TableNameID", Foreign Key named the same.
Foreign Key cannot always be named as the Primary Key. Example: OrderedProductID and ShippedProductID both pointing to ProductID (or ID) of Product table from the same table.
Automated database tools work better with option 2.