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 happens if null values are involved in datetime operations?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is normalization 1nf 2nf 3nf?
How to disable stored procedure sql server?
Which virtual table does a trigger use?
Is foreign key unique?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to use wildcard characters in like operations in ms sql server?
How to throw custom exception in Stored Procedure?
Where are stored procedures in sql server?
What is logshipping and its purpose?
How to use copy and concatenate commands in SQL?
Oracle (3253)
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)