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 code
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.
--
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*
FROMsysobjects
WHERE(xtype = 'U')
HTH
Mark Drew
On Fri, 04 Jun 2004 11:47:49 -0400, Robert Shaw
[EMAIL PROTECTED] wrote:
I know I have seen this on the
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 information
you could use
cfquery name=fetchStuff datasource=myDsn
select * from myTable
/cfquery
cfdump var=#fetchStuff#
-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 the
I'm using Oracle 9i:
SELECT object_name
FROM user_objects
WHERE object_type in ('TABLE', 'VIEW')
This will get you the table and view names.
SELECT column_name
FROM user_tab_columns
WHERE table_name = 'your_table_name_here'
This will get you the columns for that particular table.
In MS SQL Server (2000), you can use the system stored procedure sp_tables.
Issuing the command:
exec sp_tables
will list all the tables in the current database, with a column for table type (System or Table).More details are in the online help for T-SQL.
There are similar stored procs
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 column info?
Depending
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
9 matches
Mail list logo