tabledef

[EKelly]

Hello Everyone,
Im using table defs and field defs to query a database. im getting information on tables, fields and keys among other things. however i was wondering if there is any way of finding out about relationships in the database and also if there are any logical views on the database. has anyone any suggestions on this??
thanks
Erin

 

[vsuresh]

EKelly,
U didnt tell what is the database u r using. If it is MS ACCESS, you can use database.relations to get all the information of relation defined in the database.
Hope this helps.
vsuresh.