Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Ontario, Canada
    Posts
    2

    Question Unanswered: How to inquire on column headings?

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Massachusetts, USA
    Posts
    106

    Re: How to inquire on column headings?

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

    http://www.dbforums.com/showthread.p...t=column+names

    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.

  3. #3
    Join Date
    Jan 2004
    Location
    Ontario, Canada
    Posts
    2

    Thumbs up Re: How to inquire on column headings?

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

    http://www.dbforums.com/showthread.p...t=column+names
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •