Define Foreign Key?
Answers were Sorted based on User's Feedback
Answer / vani
it is a primary key which is referenced to another table
Is This Answer Correct ? | 19 Yes | 5 No |
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 |
Answer / pravati
foreign key of one table points to a primary key of another table.
Is This Answer Correct ? | 1 Yes | 0 No |
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
what is a join and explain different types of joins? : Sql server database administration
What is NOT NULL Constraint in sql server 2012?
Explain what is public role in sql server?
Explain the concepts and capabilities of sql server?
What is Command line parameters in PLSQL.?
How to find the second highest salary of an employee?
Explain some DBCC commands?
What is statement level trigger?
How to view the error log for any specific instance? : sql server database administration
How do I start sql server 2017?
What is the difference between a function and a trigger?