<div>
I have an add-in that does this, for both tables and queries. &nbsp;It is the Extras Plus add-in, a free download from my Website at this link:<br />
<br />
<a href="http://www.helenfeddema.com/Files/code20.zip" rel="ugc">http://www.helenfeddema.com/Files/code20.zip</a><br />
<br />
Here is a screen shot of the Table Fields report:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/01_w03/628482/Table-Fields-Report.jpg" target="_blank" title="Table Fields report (80 KB)"><img alt="Table Fields report" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2013/01_w03/800_628482/Table-Fields-Report.jpg" /></a>
</div>


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 [http://www.helenfeddema.com/Files/code20.zip]

Here is a screen shot of the Table Fields report:

Table Fields reporthttps://filedb.experts-exchange.com/incoming/2013/01_w03/628482/Table-Fields-Report.jpg

Table-Fields-Report.jpg

<div>
Thanks but I really just want the SQL statement
</div>


Thanks but I really just want the SQL statement

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
What SQL query would I use to get the column names and data types of all the tables<br />
in an Access database?<br />
<br />
Thanks
</div>
</div>


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

Access SQL Get column data types

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.