SQL - MS ACCESS - DESCRIBING TABLES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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