In Oracle, "SELECT * FROM cat;"

------------------------------
Jason Carvalho
Network Services Team Leader
Computer Centre
Cranfield University
Tel. 01234 754200
------------------------------

> -----Original Message-----
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
> Sent: 03 October 2002 12:57
> To: CF-Server
> Subject: RE: list of tables within a datasource
> 
> 
> Look up sp_tables
> 
> -----Original Message-----
> From: Chris Combs [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 03, 2002 7:48 AM
> To: CF-Server
> Subject: RE: list of tables within a datasource
> 
> 
> You can run a catalog query, but that query is dependent upon 
> the DBMS and your authority.
> 
> -----Original Message-----
> From: Bill Kaigler [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 9:21 PM
> To: CF-Server
> Subject: list of tables within a datasource
> 
> 
> Is there a way to get a list of available tables within a 
> datasource?  I have code that reads the fields within a table 
> but I do not know of one that will determine all available tables.
> 
> thanks,
> kaigler
> 
> 
> 
> 
> 
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to