Define Foreign Key?

Answer Posted / manoj pandey

Foreign Key is used to establish Referential Integrity/Constraint between 2 tables. Mainly it is a column in a table that uniquely identifies every record in another table. A table can have 1 or more than 1 FKs.

~Manoj (sqlwithmanoj.wordpress.com)

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain comment on transactions?

560


Explain about extended stored procedure?

494


Do you know what is a linked server in sql server?

554


What is NOT NULL Constraint in sql server 2012?

605


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

88






What is table join?

602


How to perform backup for certificates in sql server? : sql server security

599


What is the standby server?

523


What are the system database in sql server 2005?

557


Which are new data types introduced in sql server 2008?

605


how to avoid cursors? : Sql server database administration

493


What do you mean by collation recursive stored procedure?

593


What is @@rowcount in sql?

566


What are the elements of dbms?

548


Explain where clause?

537