<!--- List tables --->
<CFQUERY NAME="tables" DATASOURCE="...">
sp_tables
</CFQUERY>
<CFDUMP VAR="#tables#">
<!--- List table details --->
<CFQUERY NAME="columns" DATASOURCE="...">
sp_columns table
</CFQUERY>
<CFDUMP VAR="#columns#">
Other DBMSs have similar options.
_____
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 4:01 PM
To: CF-Talk
Subject: show tables in cold fusion
OK,
I'm having a bad day. I've googled to no avail for the last half hour. How
do you do a
show tables;
describe [table];
within CF?
thx,
Gil
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
