Select name from MSysObjects where type = 1 should do it.
----- Original Message ----- From: "mr_urc" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 2:53 PM Subject: Re: Access table names > Quoting Jerry Johnson <[EMAIL PROTECTED]>: > > > I'd try the sp_tables like in SQL Server, > > No luck on that one. Base table not found. > > > and if not that, then I'd try > > the SHOW command. > > I'm not familiar with this command and it's not listed in Access help or the > SQL book that I have with me. More info? > > Thanks for the ultra-quick response, by the way. I've got to get the first part > of a database consolidation done this afternoon. And since it's using Access, > and I can't unload tables, and the databases involved include the order > database and the tracking database, the entire site is going to have to go > offline while I do it. I'd rather be offline as little as possible, for obvious > reasons. > > > 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. > > > > > ______________________________________________________________________ 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
