Great. Thank you. :) -----Original Message----- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 4:34 PM To: CF-Talk Subject: Re: Get List of tables in a DB
Here is my snippet. <!--- First go to Tools -> Options -> click on Hidden Objects and System Objects, then go back to Tools -> Security -> User and Group permissions -> highlight the MSSysObjects table and then check the Read Data check box, then click OK.. ---> <cfquery datasource="email" name="GetTables"> SELECT name FROM MSysObjects WHERE TYPE=1 and left(MSysObjects.name,4) <> 'MSys' </cfquery> <cfoutput query="GetTables"> #name#<br> </cfoutput> -- jon mailto:[EMAIL PROTECTED] Thursday, October 10, 2002, 7:25:43 PM, you wrote: JJ> Hi, JJ> Is there a CF function or SQL statement that returns a list of table JJ> in an Access DB? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
