SQL - MS ACCESS - DESCRIBING TABLES

  • Thread starter Maxime Passenier
  • Start date
M

Maxime Passenier

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
 
M

MGFoster

Maxime said:
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?
Click to expand...

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.
 
Top