1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Define Foreign Key?

Question Posted / mohamed ibrahim

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

Is null vs coalesce?

0 Answers  

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

Explain the steps to use transact-sql cursor?

0 Answers  




What are different types of views?

0 Answers  

What are sp_configure commands and set commands?

0 Answers  

State the difference between local and global temporary tables?

0 Answers  

How to find the last update record in SQL Server?

4 Answers  

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

What are views used for?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories