Foreign key

A column in a database table containing values that are also found in some primary key column (of a different table). By extension, any reference to entities of a different type.
Some RDBMSs allow a column to be explicitly labelled as a foreign key and only allow values to be inserted if they already exist in the relevant primary key column.
[Is it still a foreign key if the primary key is in a different column in the __same__ table?]


Read Also:

  • Foreign-language

    adjective See foreign language

  • Foreign-legion

    noun 1. a military unit consisting of foreign volunteers in the service of a state. 2. (initial capital letters) a specialized military unit of the French army, consisting of volunteers of all nationalities assigned to military operations and duties outside France. noun 1. a body of foreign volunteers serving in an army, esp that of […]

  • Foreign-minister

    noun 1. (in countries other than the U.S.) a cabinet minister who conducts and supervises foreign and diplomatic relations with other states. Also called, especially British, foreign secretary. Compare (def 1). noun 1. (often capitals) a cabinet minister who is responsible for a country’s dealings with other countries US equivalent secretary of state

  • Foreign-mission

    noun 1. (def 10). 2. (def 7). noun 1. a body of persons sent to a non-Christian country in order to propagate Christianity 2. a diplomatic or other mission sent by one country to another

Disclaimer: Foreign key definition / meaning should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. All content on this website is for informational purposes only.