What your looking for is:
<CFQUERY Name="myTables" Datasource="yourDataSource">
SELECT *
FROM sysobjects
WHERE xtype = 'U'
</CFQUERY>
Type U is user tables and S is system tables. There are others, but I'm not
sure what they are.
Steven Durette
MGR. - Engineering & Construction System Support
Database Administrator/Web Developer
Ameritech/SBC
(810)466-7654 [Office]
[EMAIL PROTECTED] [work email]
[EMAIL PROTECTED] [work email]
----- Original Message -----
From: "Edward Chanter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 8:09 AM
Subject: <cfquery> Question
> I'm probably being a dunce here but does anyone know a sql query that will
> list out all the tables in a particular sql7 database...?
>
> Thanks in advance...
>
> -= Ed
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
