List Table Field Names only

  • Thread starter Thread starter js
  • Start date Start date
J

js

I always forget what the sql is to list only the table
field name, not the data...

thanks
 
This is not supported in ACCESS, but is supported in MS SQL.
 
The only way I know of to accomplish this is to use VB to
interate through the table objects then the field
objects. I don't think this can be done in Access using
SQL.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
SQL question: field name changes but is always the 1st field 2
List all not in other table 1
Join on a calculated field 3
How to find out how many fields from a specific list of fields are empty 10
dynamic calculated field in query 3
AND query 4
Access Table match or lookup or other method 0

Back
Top