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
