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

How do I debug a stored procedure in sql server?

0 Answers  


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  


What is a linked server in sql server?

0 Answers  


what is an extended stored procedure? : Sql server database administration

0 Answers  


create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,






Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  


Where do you find the default Index fill factor and how to change it?

0 Answers  


How to connect ms access to sql servers through odbc?

0 Answers  


What is difference between views and stored procedures?

0 Answers  


Can you explain the types of Joins that we can have with Sql Server?

2 Answers  


Explain contrast amongst grouped and non-bunched records?

0 Answers  


Explain indexed view?

1 Answers  


Categories