RE: displaying tablenames

[Knipp, Eric]

I don't know the answer for this specific to Access, but I can tell you that in my experience, most databases have system tables which specify schemas for all tables in the database.  From what I've seen each database platform (and sometimes each version) has its own way of describing this information.  This is where I would start looking.

 

Good luck,

 

Eric

-----Original Message-----
From: Ron Mast [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 9:43 AM
To: list@dfwcfug.org
Subject: displaying tablenames

Hi All,

Is there a way to display all the tables in an access database, or any database in CF?  Thanks in advance.

 

Ron Mast

Webmaster

Truth Hardware

Ph: 507-444-4748

Fx: 507-444-5361

www.truth.com

 

_______________________________

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual to whom they are addressed.  If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.

---

CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this e-mail in error, please immediately notify the sender and delete it from your system.