Define Foreign Key?

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

What happens if null values are involved in datetime operations?

1 Answers  


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1 Answers  


What is normalization 1nf 2nf 3nf?

1 Answers  


How to disable stored procedure sql server?

1 Answers  


Which virtual table does a trigger use?

8 Answers   TCS,


Is foreign key unique?

1 Answers  


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1 Answers   HCL, Wipro,


How to use wildcard characters in like operations in ms sql server?

1 Answers  


How to throw custom exception in Stored Procedure?

1 Answers   MCN Solutions,


Where are stored procedures in sql server?

1 Answers  


What is logshipping and its purpose?

1 Answers  


How to use copy and concatenate commands in SQL?

1 Answers   Amdocs,


Categories