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
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
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
: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
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
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
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
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
>>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.
--
_
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]
10 matches
Mail list logo