Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

When can an insert of a new primary key value threaten
referential integrity?

Answer Posted / naveen

When this primary key is also a foreign key to another
table and that table is not having the value you are trying
to insert.

RI constraint doesn't allow you to insert a primary key
value into your table if its not present in table your are
having constraint with

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 the use of value function?

1151


What is db2 look?

1026


Can there be more than one cursor open for any program?

1169


Why cursor is used in db2?

1036


What are the 2 sqlcodes that are returned?

1190


What is cursor stability in db2?

1358


What is check constraint. Explain with example.

1109


What is a storage group (stogroup)?

1246


How to compare data between two tables in db2?

1088


How to create db2 table in mainframe?

1154


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1439


How to find the maximum value in a column in the db2 database?

1084


What is the difference between using bind () and rebind () methods of naming class?

1401


What is the syntax for FETCH in DB2 ?

1216


What is a db2 collection?

1048