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. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
