How to return db headers in ASP?

[Nochurch]

I would like to return the names of the columns of a particular table in my database. Anyone knows how to do this?

[raf]

Depends on the DB that you are using. For MySQL there are some nice PHP functions for that + the equivalent MySQL commands that you can use in embedded SQL inside ASP.

For MsAccess and MsServer, you can use the ADO OpenSchema. Here's some info and example code
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q186/2/46.asp&NoWebContent=1