This will work; note that you must make the system tables visible (they are hidden by default)
--- Billy Cravens -----Original Message----- From: Scott Brader [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:53 PM To: CF-Talk Subject: RE: Access table names You can get a list of all tables in an Access database by querying the system tables. The system tables will all start with MSys. All of the other records returned by the query will be the rest of the tables in the database. SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=1)); This may not be the best choice, but it works. Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 <http://www.prairiesoftdev.com> Amateurs practice until they get it right, Experts practice until they can't get it wrong. -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 14:49 To: CF-Talk Subject: Re: Access table names I'd try the sp_tables like in SQL Server, and if not that, then I'd try the SHOW command. My mind tells me that one of these works, but can't remember which one. Jerry Johnson >>> [EMAIL PROTECTED] 04/30/02 03:32PM >>> I'm not liking Access this morning. I'm a bit cranky that it won't let me unload tables. I think I need to drink more coffee. Anyhoo, I'm hoping to find a way to select the names of all of the tables in a database using SQL. I've already searched google and the MS website, and I can't find a way to do it. Does anybody know how I can do this easily and in SQL? I hoping for a select * from [schematablename] like I can do in SQL server and Oracle. But since I can't unload, I'm not counting on it to be available. Ahhhh, to be onsite and not have my books with me.... -- If you hate the interface, blame Kevin. ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
