?
Solved

Access SQL Get column data types

Posted on 2013-01-16
4
Medium Priority
?
518 Views
Last Modified: 2013-01-16
Hi

What SQL query would I use to get the column names and data types of all the tables
in an Access database?

Thanks
0
Comment
Question by:Murray Brown
  • 2
  • 2
4 Comments
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 38783880
I have an add-in that does this, for both tables and queries.  It is the Extras Plus add-in, a free download from my Website at this link:

http://www.helenfeddema.com/Files/code20.zip

Here is a screen shot of the Table Fields report:

Table Fields report
0
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 2000 total points
ID: 38783883
The add-in works with all Access versions from 2003 through 2010 (not yet tested in 2013).
0
 

Author Comment

by:Murray Brown
ID: 38783927
Thanks but I really just want the SQL statement
0
 

Author Closing Comment

by:Murray Brown
ID: 38784094
thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question