describe <table_name> (used in ORACLE. Is there some thing like this in ACCESS?)

[shaileshak]

describe <table_name> (used in ORACLE. Is there some thing like this in ACCESS?)

I just want to export/save the structure of a table to any text format so that I can use this for my documentation rather than typing it all once again. In ORACLE using DESCRIBE command we can get the structure of a table. Is there any way I can achieve this in access?

Can anybody help please ?

shaileshak

 

[RV]

Tabelstructure

In ORACLE databases one can use, for example, SQL*PLUS to describe database tables.
You can define a database connection with MS Access using SQL*PLUS.
Only condition is you've got at least version SQL*PLUS 8.0.6.

Thus, you should be able to use DESC[RIBE] to get a description of your tablestructure.
Ask your DBA'ers for more info (it's a rather specific database topic far beyond my knowledge and interest).

Another option is to use VBA code to get the description of MSAvvess objects.
Or buy an applic to analyze MSAccess, such as Total Access Analyzer (if I do remember the correct name).

I'd advice to go for the SQL*PLUS option.

HTH,

RV

 

[shaileshak]

Many thanks for the fast reply.
I hope this would help me.

shaileshak

 

[shaileshak]

Hi Pat,

thanks for your help.
I found it more useful than I thought.

shaileshak