Hi, The table you are looking for is INFORMATION_SCHEMA.CROSS_REFERENCES:
create table parent(id int); create table child(id int, pid int references parent(id)); SELECT * FROM INFORMATION_SCHEMA.CROSS_REFERENCES ; Regards, Thomas On Wed, Aug 27, 2008 at 10:21 AM, vkboss <[EMAIL PROTECTED]> wrote: > > Hi, > > Given an table, i would like to obtain all FKs from this table and > thus, which tables it depends on. I tried to obtain this in > "information_schema.constraints" with no sucess. > > Thx for any help. > > Regards. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
