Mapping tables

[Guest]

I currently have an ODBC connection to our manufacturing systems database
which consists of approx 150 tables.

Is there anyway I can print or extract a list of ALL the tables along with
their fields, so that I can start to build a map of all the links to make it
easier to build quiries.

Also we are not supported by our manufacturing systems providor for extrenal
data therefore I have to search through each table one at a time to find
where certain data is store. If I have a list it maybe a little easier.

Regards

 

[aaron.kempf]

is your system SQL Server?


you should just learn Access Data Projects; linking tables and mapping
tables names; etc-- this is too difficult for new users.
just build an Access Project (existing data) and then you can build
views and sprocs in one place-- without any of the headaches

HTH I feel your pain

-Aaron