adspace


what is foreign key? : Sql dba

Answer Posted / Awashesh Kumar Tiwari

A foreign key is a field or set of fields in one table that refers to the primary key of another table. It enforces referential integrity by ensuring that relationships between tables are maintained, and it improves data consistency by preventing invalid data from being inserted into the database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current version of postgresql?

1178


Do we need to rebuild index after truncate?

1138


If a cursor is open, how can we find in a pl/sql block?

1238


What is the current version of sql?

1094


What is your daily office routine?

2346


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2091


how to start mysql server? : Sql dba

1267


How do I remove duplicates in two columns?

1187


what are all the common sql function? : Sql dba

1131


what is dbms? : Sql dba

1061


what is sql server agent? : Sql dba

1182


what are the advantages of sql ? : Sql dba

1142


Can delete statement be rollbacked?

1054


how to use regular expression in pattern match conditions? : Sql dba

1113


Can we use distinct and group by together?

1133