that was the answer :)
Select * from information_schema.tables
actually, so that I can strip out the system ones...
Select * from information_schema.tables
where table_name not IN ('dtproperties','sysconstraints','syssegments')
thanks john!
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-----Original Message-----
From: Jeff Garza [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 10:35 AM
To: CF-Talk
Subject: Re: query to get tablenames
Which Database??? It's different for each one.
Jeff
----- Original Message -----
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 8:31 AM
Subject: query to get tablenames
what is the variable or query that will show me tables in a database, so
that I can
then, select that table to perform a query on?
thanks
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
