For Oracle:
select table_name from all_all_tables
all_all_tables describes tables accessible to the current user.
user_all_tables described tables owned by the current user.
Oracle 8i reference:
http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76961/toc.htm
-David
On Friday, June 08, 2001 9:20 AM, Ricq Pattay [SMTP:[EMAIL PROTECTED]] wrote:
> If you are the Oracle owner of the tables in question, you can use "select
> table_name, table_type from user_catalog". If you're not the owner, I think
> you're out of luck.
>
>
> ----- Original Message -----
> From: "Jim Watkins" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, June 08, 2001 9:17 AM
> 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
