Define Foreign Key?

Question Posted / mohamed ibrahim

3 Answers
8739 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

Does a full backup include transaction log?

0 Answers

Is mysql better than sql server?

0 Answers

Define Check points and End Points?

1 Answers

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers

How to list all tables in the database using odbc_tables()?

0 Answers

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers

How to determine the service pack currently installed on SQL Server?

4 Answers HCL,

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers

How do I find the port number for sql server?

0 Answers

Define Unique Key?

0 Answers HCL,

What is trigger ?

7 Answers Cap Gemini, SQL,

How to delete a database in ms sql server?

0 Answers

For more SQL Server Interview Questions Click Here