`show databases` will list all databases you have access to via the DSN.
`show tables` will list all tables in the database the DSN is connected to.
`show tables in <dbname>` will list all tables in the named database.
`explain <tablename>` will list the columns of the named table. You can use
cross-database tables by saying <dbname>.<tablename>
Cheers,
barneyb
> -----Original Message-----
> From: brobborb [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 07, 2004 1:26 PM
> To: CF-Talk
> Subject: Find out table names and fields?
>
> Hey guys, I have a host that has no web admin support for
> mySQL. I mean, they have MySQL running, but no admin. At
> least thats what I'm told by my client. I was wondering if
> there was a way to extract the table names and fields using
> coldfusion instead. Would that be possible?
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
