copy or pirint table structure

[lostboy]

Please, tell me there's a simple way to get a copy of a
table structure. All I want is a list of field names,
types and sizes. No data, just the structure of the
table. Twenty years ago, in dbaseIII, you could get this
with one or two words at the comand prompt - something
like "print filestruct."

 

[fredg]

Please, tell me there's a simple way to get a copy of a
table structure. All I want is a list of field names,
types and sizes. No data, just the structure of the
table. Twenty years ago, in dbaseIII, you could get this
with one or two words at the comand prompt - something
like "print filestruct."

Tools + Analyze + Documenter

Make sure you set all your options or else be prepared with lot's of
paper.

 

[John Vinson]

Please, tell me there's a simple way to get a copy of a
table structure. All I want is a list of field names,
types and sizes. No data, just the structure of the
table. Twenty years ago, in dbaseIII, you could get this
with one or two words at the comand prompt - something
like "print filestruct."

Tools... Analyze... Documentor.

Check the settings - by default it prints out a HUGE volume of
details.

 

[Albert D. Kallal]

You can print out the tables two ways:

Of course, you use the fabulous "relationships" window, and layout all your
tables.

You can then print out the above (in access 97, you need a add in), for
a2000 and later, you can printout this document. Not only will you see all
the fields, but also get all the relationships between the tables. In fact,
once development gets under way....I print out that diagram and put it up on
the wall (at least I do for large projects in the "heat" of development
stage). Here is a nice screen shot of what I mean:

http://www.attcanada.net/~kallal.msn/Articles/PickSql/Appendex2.html

In addition, you can right click any table in the relationships window and
jump right into design mode. This graphical screen is fabulous from a
relational design point of view.

All I want is a list of field names,
types and sizes.

Yes, you can also do that (but why, when you have the fabulous relationships
window?).

Anyway, to print out just the fields names, go:

tools->Analyze->Documenter

Select the tables tab, and then select what tables you want to list out.

MAKE SURE YOU WHACK THE OPTIONS BUTTON!!!! In there you need to turn off the
extra stuff that ms-access tries to print (if you don't do this...you will
kill a whole bunch of trees, as the paper output will be HUGE...and print
out TONS AND TONS of stuff that you DO NOT likely want). In fact, you will
not even get a columnar listing of the field types.

However, play around. The settings you need to use to get JUST the columns
as you ask is in the options page is:

In the case of tables...uncheck the

Include for Table
[ ] Properties
[ ] Relationships
[ ] Permissions by Users and Group

Include for fields
[ ] Nothing
[x] Names, Data Types, and Sizes
[ ] Names, Data Types, and Sizes, and Properties

Include For Indexes
[x] Nothing
[ ] Names and Fields
[ ] Names, Fields, Properties


You can also document your whole project. Play around with the
documenter...it can print out as much stuff as you want to impress the boss!