Explain foreign key in sql?
Answer / Kundan Kumar Vats
A foreign key is a field or set of fields in one table that refers to the primary key of another table. It establishes a link, or relationship, between two tables, enabling data from both tables to be related. A foreign key helps maintain data integrity by ensuring referential consistency, preventing orphaned records and other errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I turn a list into a table?
What is the difference between sql/pl-sql/embeded sql?
What are the sql aggregate functions?
How do you define a foreign key?
Is merge a dml statement?
What does pragma mean?
What is Temp Table and type of temp table?
how a reference cursor works?what all adnvantages are gained with it..specify the situation?
What is window clause?
what is msql? : Sql dba
What are the different dml commands in sql?
What are the constraints available in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)