Define Foreign Key?

Question Posted / mohamed ibrahim

3 Answers
8708 Views
ADP, College School Exams Tests, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Define Foreign Key?..

Answer / vani

it is a primary key which is referenced to another table

Is This Answer Correct ?

19 Yes

5 No

Define Foreign Key?..

Answer / 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

Define Foreign Key?..

Answer / pravati

foreign key of one table points to a primary key of another table.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL Server Interview Questions

The Difference between 'Count' and 'Count(*)'

13 Answers

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers DELL,

What is query processing?

0 Answers

How can you swap values between two rows in a table using single- SQL statement?

1 Answers Tavant Technologies, Virtusa,

What is database replication?

0 Answers

what are defaults? : Sql server database administration

0 Answers

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers

How do I port a number to sql server?