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 |
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
How many null values we can have in a unique key field in sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are difference between Cluster index and Non-Cluster index?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are the difference between “where” and “having” clause in sql server?
What is sql view?
How to select some specific rows from a table in ms sql server?
What are security principals used in sql server 2005?
What is difference between order by and group by?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)