SQL - MS ACCESS - DESCRIBING TABLES

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maxime Passenier - 03 May 2005 16:59 GMT

I have to write a query that describes the tables in a given database.

In mysql it is something like this: "describe tables".

Can anyone tell me how it is written in access?

Thank you

Reply to this Message

MGFoster - 03 May 2005 21:00 GMT

> I have to write a query that describes the tables in a given database.
>
> In mysql it is something like this: "describe tables".
>
> Can anyone tell me how it is written in access?

Depends on what MySQL displays on that command. There is a
documentation option (Tools > Analyze > Documenter) that will display
all the properties of a table.

If you mean the DDL definition of a table, there are routines all over
the net that do that. Search Google.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message