Foreign key
database
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?]
(2005-01-14)
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
- Foreign national
noun any person who is not a citizen or permanent resident alien of the US