How to inquire on column headings?

masha · #1 (**permalink**) 01-14-04, 00:55

Hello!
I'd like to be able to find out, programmatically, what field names are there in a particular table. I use JScript and an MS Access database.
Also, if possible, if there is a particular table in the database.
And to do it so that no error message is generated.
Is there a way in SQL? I spent considerable time looking for an SQL syntax for that query, without any success.

dmmac · #2 (**permalink**) 01-16-04, 15:55

There is a MS Access forum on this site. The below should help you out:

Dynamical Column Retrieval

Quote:

Originally posted by masha
Hello!
I'd like to be able to find out, programmatically, what field names are there in a particular table. I use JScript and an MS Access database.
Also, if possible, if there is a particular table in the database.
And to do it so that no error message is generated.
Is there a way in SQL? I spent considerable time looking for an SQL syntax for that query, without any success.

masha · #3 (**permalink**) 01-16-04, 20:03

Quote:

Originally posted by dmmac
There is a MS Access forum on this site. The below should help you out:

Dynamical Column Retrieval

Thank you very much! That solves it indeed.
Sorry for posting in this forum. I did it because I hoped that it were possible using pure SQL.
Thanks again!

Internet Services

Web Development

Digital Marketing

Consumer Tech