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 1 · Accepted Answer · answered Feb 10 '10 at 00:45

1

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

score 0 · Answer 2 · edited Jul 16 '23 at 06:21

0

You can write a SQL query like this:

SELECT * FROM [sometablename] WHERE 1<>1 or
SELECT * FROM [sometablename] WHERE 1=2

This will result no row data but with field names.

edited Jul 16 '23 at 06:21

srn

answered Jul 11 '23 at 16:07

Hemu

2 Answers2