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 2nf in normalization?
How to view existing indexes on an given table using sys.indexes?
When would you use a before or after trigger?
Do you know exporting and importing utility?
How to verify a login name with sqlcmd tool?
What is Cross Join
Wht is SQL Injection Attack ?
what are default? Is there a column to which a default cant be bound?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Explain error handling in ssis?
What are the requirements for sql server 2016?
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)