Googled this, so have no specific knowledge: SELECT TABLE_NAME FROM ALL_TABLES;
MySQL - SHOW command SQL Server - SP_TABLES, SP_COLUMNS Jerry Johnson >>> [EMAIL PROTECTED] 02/04/03 03:20PM >>> Excellent! Does anybody have an Oracle equivalent? > -----Original Message----- > From: Eric Creese [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 04, 2003 2:20 PM > To: CF-Talk > Subject: GET TABLES IN DATASOURCE / GET FIELDS IN TABLE > > > SELECT sysobjects.id as tableid,sysobjects.name as tablename, > syscolumns.name as columnname > FROM sysobjects, syscolumns > WHERE sysobjects.type = 'U' > AND sysobjects.id = syscolumns.id > ORDER by sysobjects.id > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
