If I may reply to that, it is only functional in SQL Server. Paul W. Wille [EMAIL PROTECTED] -------------------------------------------------- Certified Advanced ColdFusion 5 Developer -------------------------------------------------- ISITE Design, Inc. � Solutions Architect www.isitedesign.com 503.221.9860 x110 888.269.9103 503.221.9865 fax
-----Original Message----- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 3:32 PM To: CF-Talk Subject: Re: SQL for grabbing list of tables in DB / fields in table? > SELECT so.name, sc.name > FROM sysobjects so, syscolumns sc > WHERE so.type = 'U' AND so.ID = sc.ID This doesn't seem to work with Access DB. Is there an equivalent? Which DBMS is this code compatible with? cheers, - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
