RE: Get Database Tables, etc

2004-06-05 Thread Greg Luce
What database? MSSQL I use sp_tables. -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:48 AM To: CF-Talk Subject: Get Database Tables, etc I know I have seen this on the list before but I can't find the exact code. Does anyone have the

Re: Get Database Tables, etc

2004-06-04 Thread Jochem van Dieten
Robert Shaw wrote: > This is DB2 on MX... DB2 doesn't use the information schema, but the syscat schema: http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2s003.htm#ToC_557 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe

RE: Get Database Tables, etc

2004-06-04 Thread Robert Shaw
This is DB2 on MX... -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:52 AM To: CF-Talk Subject: Re: Get Database Tables, etc >>Does anyone have the code for querying a database and returning a list of tables and/or colum

RE: Get Database Tables, etc

2004-06-04 Thread Shawn Grover
:48 AM To: CF-Talk Subject: Get Database Tables, etc I know I have seen this on the list before but I can't find the exact code. Does anyone have the code for querying a database and returning a list of tables and/or column info? TIA, Robbie   _ [Todays Threads] [This Me

RE: Get Database Tables, etc

2004-06-04 Thread Semrau Steven Ctr SAF/IE
4 11:48 AM To: CF-Talk Subject: Get Database Tables, etc I know I have seen this on the list before but I can't find the exact code. Does anyone have the code for querying a database and returning a list of tables and/or column info? TIA, Robbie   _ [Todays Threads] [This Message] [Su

Re: Get Database Tables, etc

2004-06-04 Thread mavinson
you could use select * from myTable -mike "Robert Shaw" <[EMAIL PROTECTED]> 06/04/2004 11:47 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc:         Subject:    Get Database Tables, etc I know I have seen this on

Re: Get Database Tables, etc

2004-06-04 Thread Jochem van Dieten
Robert Shaw wrote: > I know I have seen this on the list before but I can't find the exact code. > Does anyone have the code for querying a database and returning a list of > tables and/or column info? If your database is compliant with the SQL spec you can get all off that from the informatio

Re: Get Database Tables, etc

2004-06-04 Thread Mark Drew
Depends on the DB, I know that you can do "show tables" with mySQL for MS SQL you can do a query to the sysobjects table as follows: SELECT * FROM sysobjects WHERE (xtype = 'U') HTH Mark Drew On Fri, 04 Jun 2004 11:47:49 -0400, Robert Shaw <[EMAIL PROTECTED]> wrote: > > I know I

Re: Get Database Tables, etc

2004-06-04 Thread Claude Schneegans
>>Does anyone have the code for querying a database and returning a list of tables and/or column info? Depending on the database you're using, there is some code possible, but not for all databases. For any kind of ODBC database, CFX_ODBCInfon is the sure way. See the address below. -- _

Get Database Tables, etc

2004-06-04 Thread Robert Shaw
I know I have seen this on the list before but I can't find the exact code. Does anyone have the code for querying a database and returning a list of tables and/or column info? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]