What are foreign keys?

Answer Posted / vamsikrishnamraju

A foreign key is a referential constraint between two
tables.The foreign key identifies a column or a set of
columns in one (referencing) table that refers to a column
or set of columns in another (referenced) table. The
columns in the referenced table must form a primary key or
unique key.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a bind in db2?

760


What is the role of union all and union

857


Mention the location where the output received from explain statement is stored.

840


How does coalesce work?

750


What is the maximum size of varchar data type in db2?

835


What does db2 plan contain?

748


How to get the ddl of a table in db2?

856


Is it possible using max on a char column?

830


Is ibm db2 open source?

797


What is the physical storage length of timestamp data type?

848


What is the use of dclgen in db2?

783


What is load utility in db2?

870


How to view db2 table structure?

780


What are the prerogatives?

797


How can you find out the # of rows updated after an update statement?

850