sp_helpdb and the db name

-----Original Message-----
From: Paul Hastings [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 12:55 AM
To: CF-Talk
Subject: Re: Get list of tables from a SQL Server DB


> Is there any way I can get the list of tables in a SQL 2000 DB
> programmatically ? I guess what I need is a limited form of sp_help, as
> long as it just gives me all the user-created tables, system tables not

grab the cf_sql pack from my shop's site. http://www.tei.or.th/eic/
under the "free" menu link. it includes that functionality among others.


______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to