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 |
Explain syntax for viewing trigger?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is conditional split?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Explain what is meant by replication of database?
Do you know concepts and capabilities of sql server?
How can we write or define DDL statements in Sql server and DML statements?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What are primary keys and foreign keys?
Explain what is the difference between a local and a global temporary table?
What is merge join?
How do I debug a stored procedure in sql server?