Introduction › Foreign Keys › Identification of Foreign Keys and Targets

Identification of Foreign Keys and Targets

Column name identifies foreign keys and their targets:

• Foreign keys have column names ending in _ID (underscore ID).
• Targets are in columns named ID.

Often the name of the foreign key (without _ID) is the same as the name of the view that contains the target.