Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/Databases
Databaseseasy

What is a foreign key and what does it enforce?

Tags
#foreign-key#constraints#integrity
Back to categoryPractice quiz

Answer

A foreign key is a constraint that links a column to a referenced primary/unique key in another table. It enforces referential integrity: you can’t reference a row that doesn’t exist (and it can control delete/update behavior).

Related questions

Databases
Foreign keys: why use them and what’s a trade‑off?
#database#foreign-key#integrity
Databases
Primary key vs unique constraint: what’s the difference?
#database#constraints#primary-key
Databases
Constraints vs triggers — what’s the difference and what do you prefer for integrity?
#constraints#triggers#integrity
Databases
Primary key vs unique constraint vs index — what’s the difference?
#primary-key#unique#index