Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: Field Name Appear In Query

    I need the field name of a table to appear as data in a query.

    How could I do this?


  2. #2
    Join Date
    Dec 2002
    in your sql query you need to use: describe my_tbl_name

    so if your table is members

    you may have had a select query: select * from members
    you now use: describe members

    I have not tested this to make sure that it works as I have never had a use for it but if it does I would be interested in knowing. If it doesn't let me know and I will see if I can get someting that does.

Posting Permissions

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