Subject Running a query to find table constraints
Author tractaylor
Hello All:

I am wondering if there is a way to query the database to find out the
order I need to insert records into the database. In other words, I
have a master detail relationship. I would like to run a query to get
a list showing me that I need to insert into the Master table then the
detail.

Some like an Orders and Order_Detail table. I could run a query and it
would somehow tell me there is a foreign key on Order_Detail that
points to Orders.....

Does this make since? And is this possible?

Thanks
Trac