CODEWITHSUNDEEP
sqlms-accessjet
Abs
Abs

Reputation: 57916

Get all field names in Microsoft Access Table using SQL

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

Thanks all

Upvotes: 3

Views: 6171

Answers (2)

Hemu
Hemu

Reputation: 29

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.

Upvotes: 0

Abs
Abs

Reputation: 57916

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!

Upvotes: 1

Related Questions