What is the purpose of the FOREIGN KEY constraint in a relational database?
- Concatenates columns
- Defines a primary key
- Ensures referential integrity
- Limits the number of rows
The FOREIGN KEY constraint in a relational database is used to ensure referential integrity between two tables. It establishes a link between the data in two tables, ensuring that relationships between them are maintained.
Loading...
Related Quiz
- Which database indexing technique helps in optimizing query performance by storing data in a sorted order?
- Which programming construct is commonly used for catching and handling errors in JavaScript?
- How does Git mark merge conflicts in the affected files?
- What is the purpose of a data structure?
- The GROUP BY clause is used to _______ data in a result set based on specified columns.