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 |
How do I debug a stored procedure in sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is a linked server in sql server?
what is an extended stored procedure? : Sql server database administration
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Where do you find the default Index fill factor and how to change it?
How to connect ms access to sql servers through odbc?
What is difference between views and stored procedures?
Can you explain the types of Joins that we can have with Sql Server?
Explain contrast amongst grouped and non-bunched records?
Explain indexed view?