with oracle it's pretty easy, it's metadata is stored in system tables.
select table_name from all_tables;
depending on the roles/permissions you have set up tho you may have better luck with:
select table_name from user_tables;
----Original Message Follows---- From: "Ron Mast" <[EMAIL PROTECTED]> Reply-To: [email protected] To: <[email protected]> Subject: displaying tablenames Date: Tue, 3 May 2005 09:43:27 -0500
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.
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
