in CF I think queryname.fieldslist gets you the list of fields from a table in a query. You have to have the table name first though obviously.
Michael Corrigan Programmer Endora Digital Solutions 1900 S. Highland Avenue, Suite 200 Lombard, IL 60148 630/627-5200 x-136 630/627-5255 Fax ----- Original Message ----- From: Gyrus To: CF-Talk Sent: Wednesday, January 09, 2002 4:33 PM Subject: SQL for grabbing list of tables in DB / fields in table? Does anyone know if there's an SQL statement for grabbing a list of the names of tables in a DB, or of field names in a table? I'm working in Access / SQL Server. cheers, - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
