Verification of foreign keys [message #458232] |
Fri, 28 May 2010 00:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
SaritaP
Messages: 3 Registered: May 2010 Location: India
|
Junior Member |
![sarita_mitali%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
I am working on a legacy application which consists of a database with no foreign keys.So,as a client reqt. I retrieved the foreign keys from the database using a script which identifies foreign keys based on the database schema and data in the tables.Now I am required to use their database logs to verify the extracted keys.These logs consist of only INSERT,UPDATE and DELETE statements.Does an INSERT followed by an UPDATE or vice-versa would be sufficient condition to say there exists a foreign key-primary key relationship between these two tables?Or should I be looking at some other aspects?
|
|
|
|
|
|
|
|