Get all field names in Microsoft Access Table using SQL

Question

How do I get all the field names in a Table in Microsoft Access using JET SQL?

Thanks all

Uh, VBA != SQL. Of course, you can use VBA, or C# or VB.NET or vbScript or any language you want as long as it can connect to a driver that can read your Jet database. — David-W-Fenton, Feb 09 '10 at 22:01

score 0 · Accepted Answer · answered Feb 10 '10 at 00:45

0

I was making using of the ODBC extension in PHP and it has a function to do this!

In case anyone needs this in the future its, odbc_tables!

answered Feb 10 '10 at 00:45

Abs

I do need it, but for Perl, and its DBD::ODBC doesn't appear to support an equivalent. – reinierpost Feb 27 '11 at 10:58
For python if you are using pyodbc check out this thread: https://stackoverflow.com/a/16328498. – KetZoomer Sep 15 '20 at 22:08

1 Answers1