English » German

Translations for „foreign key“ in the English » German Dictionary (Go to German » English)

foreign key N

User Entry

- Reedit this entry
- Recommend deletion

foreign key COMPUT

Fremdschlüssel m

Monolingual examples (not verified by PONS Editors)

English

A fact table typically has two types of columns: those that contain facts and those that are a foreign key to dimension tables. en.wikipedia.org

The foreign key can be used to cross-reference tables. en.wikipedia.org

For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. en.wikipedia.org

Here is an example of a primary key becoming a foreign key on a related table. en.wikipedia.org

In particular, natural join allows the combination of relations that are associated by a foreign key. en.wikipedia.org

Persistent columns can be indexed and can be part of a foreign key, with a few small limitations concerning constraint enforcement. en.wikipedia.org

In other words, when a foreign key value is used it must reference a valid, existing primary key in the parent table. en.wikipedia.org

Finally, overlapping value sets possibly representing foreign key relationships between entities can be explored in an inter-table analysis. en.wikipedia.org

File cross-connects or joins are handled as a synonym definition of the foreign key. en.wikipedia.org

Most primary key indexes, foreign key indexes and software codes for categorized textual values can be replaced with their natural language equivalents. en.wikipedia.org

Would you like to add some words, phrases or translations?

Submit a new entry.

Browse the dictionary

English

Look up "foreign key" in other languages

Arabic

Choose your language Deutsch | български | Ελληνικά | English | Español | Français | Italiano | Polski | Português | Русский | Slovenščina | Srpski | Türkçe | 中文