Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 View Colums of ODBC tables

Author  Topic 

DLTaylor
Posting Yak Master

136 Posts

Posted - 2007-03-23 : 10:13:11
I have an Access 2000 DB.

All the tables are linked via ODBC to a SQL DB.
I would like to have a query that showed me all the Table names and the Colum names.

In my database options menu I can unhide System objects - this gives me the table names - is there a way to view the colum names as well?

Your help would be much appreciated.
   

- Advertisement -