Subject | Running a query to find table constraints |
---|---|
Author | tractaylor |
Post date | 2005-08-19T19:09:17Z |
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
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