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
– David-W-Fenton, Commented Feb 9, 2010 at 22:01

Abs · Accepted Answer · 2010-02-10 00:45:17Z

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, 2010 at 0:45

Abs

58.2k104 gold badges282 silver badges419 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I do need it, but for Perl, and its DBD::ODBC doesn't appear to support an equivalent.

For python if you are using pyodbc check out this thread: stackoverflow.com/a/16328498.

srn · Accepted Answer · 2023-07-16 06:21:23Z

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.

srn

1,3192 gold badges11 silver badges18 bronze badges

answered Jul 11, 2023 at 16:07

Hemu

299 bronze badges