SELECT * FROM tab; ....will give you all the table availables for you in oracle Mario Talavera Developer http://www.joepix.com -----Original Message----- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 10:18 AM To: CF-Talk Subject: Re: How to get a list of all tables in a given datasource - and how to combine queries Does anyone have the code to get a list of Tables from an Oracle database? ----- Original Message ----- From: "Diana Nichols" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 9:08 AM Subject: RE: How to get a list of all tables in a given datasource - and how to combine queries > This will give you a list of the tables within a SQL database: > > <cfquery name=getTables datasource=#dsn#> > select table_name from information_schema.tables > </cfquery> > > <cfoutput query=getTables> > #table_name# > </cfquery> > > You should then be able to combine the data from both queries in whatever > way you want. > > HTH > D > ************* > Diana Nichols > Webmistress > http://www.lavenderthreads.com > 770.434.7374 > > "One man's magic is another man's engineering." ---Lazarus Long > > > -----Original Message----- > From: JoshMEagle [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 08, 2001 8:34 AM > To: CF-Talk > Subject: How to get a list of all tables in a given datasource - and how > to combine queries > > > Have two questions .... > > First, given the name of a datasource, how do I go about finding what tables > are contained in the datasource via CF (not just opening SQL Server) > > Second, I have a query of all the datasources on my server using > <cfregistry> that is returned as a query ... how can I combine this > information with the query to display the tables into one query? Is this > even possible? > > THANKS! > > Joshua Miller > Web Development > Eagle Technologies Group > Technology Solutions for the Next Generation > www.eagletgi.com > [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
