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

What are the differences between having and where clause.

553


What are various ways to enhance the ssrs report?

528


How to connect of datebase with sql express.?

618


What is the difference between TRUNCATE and DROP?

626


What are sub reports and how to create them?

99






what is a check constraint?

632


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

501


which table keeps the locking information? : Sql server administration

517


How many levels of sp nesting is possible?

580


What is acid db?

506


Why use view instead of a table?

513


Write a program using SQL queries to find a unique entry in a table.

540


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1571


What is implicit cursors?

551


What is data source in connection string?

488