[thelist] show all tables - ColdFusion, MSAccess, SQL (again)

.jeff jeff at members.evolt.org
Tue Jun 26 22:24:23 CDT 2001


jon,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: jon steele
:
: I need to show all the tables in a database.
: I just need a list of them. I know in mysql
: there's a show statement, but how can I do
: this for an Access db from ColdFusion.
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

one good place for looking for applications like this is the custom tag
gallery on allaire.com.

http://devex.allaire.com/developer/gallery/

a search for "tables" turned up the following promising results:

CF_AccessTables
<http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34785A-2830-11D4-A
A9700508B94F380&method=Full>

CF_DBINFO
<http://devex.allaire.com/developer/gallery/info.cfm?ID=8C6EAA32-24FA-11D5-8
3EF00508B94F85A&method=Full>

CFX_GetTables
<http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3475EA-2830-11D4-A
A9700508B94F380&method=Full>

using other words you might be able to come up with even more fruitful
results.

good luck,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/






More information about the thelist mailing list