SELECT table_name, column_name (or select * for more info) FROM user_tab_columns ORDER BY table_name, column_id
This is for the current user you're logged into Oracle as. We generally don't create DSN's that connect as user's that own any tables so this is best done in SQL Plus or TOAD. Duncan Hays -----Original Message----- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 3:21 PM To: CF-Talk Subject: RE: GET TABLES IN DATASOURCE / GET FIELDS IN TABLE 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
