Re: Reg ForeignKeys
Yee Konstantin Osipov .. first of all Thank u for the reply
ya I have tried all
SHOW CREATE TABLE will give total table structur including foreignKeys and all info..
but to axtract only foreignKeys and their info like On delete cascade there we have to do whole lot of parsing and it will not be accurate all the time
and
SHOW KEYS FROM table_name will not disply foreignKeys..
and
INFORMATION_SCHEMA.KEY_COLUMN_USAGE gives all foreign keys
but it wont disply information like ondelete cascade..
in there any alternate plz let me know..
and also thanx for the reply to my posting regarding views
Subject
Views
Written By
Posted
720
December 27, 2005 02:20AM
422
December 27, 2005 05:41AM
Re: Reg ForeignKeys
470
January 03, 2006 11:52PM
415
January 07, 2006 05:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.