Query Table Properties

S

Spartanmba

Is there a way to query properties of a table(s)? I cannot seem to find an
answer. I am wanting to pull back the properties for each column that are
in a table.

Thank you,
John
 
K

KARL DEWEY

Try the TOOLS - Database Documentor
- click on the Tables tab
- select your table
- click options
- under Include For Fields select Names, Data Types, Size, and Properties.

Click OK, click OK. You can then take it out to Word for further review.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query the same table three times 0
Consolidation Table from Different Excel Tabs with Different Format 1
Creating a Chart on form from selected data in query. 0
Format column widths from one table to a separate table on same page 1
Delete all data after a symbol in a field 0
query to show where no data in a stated column 0

Top