Does Access have an equivalent to Oracle's DESCRIBE

[jpaaron]

I'm trying to return table names in an Access DB via SQL. Is this possible. Oracle has a reserved word that does this called DESCRIBE.

 

[KenReay]

Hi

I am not aware of a direct replacement for DESCRIBE but:

You can do this in code by iterating through the tabledefs collection.

Or

You can do it using a query based on the system table MSysObjects. This table contains details of objects other than tables so you will have to choose an appropriate criteria, try SELECT * FROM MSysObjects WHERE Type = 6, to begin with

Regards Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use