show tables
</cfquery>
<cfdump var="#get#" />
These are MySQL-specific commands. They may or may not work on other
database system. I believe MS SQL has a stored procedure that you query for
information about the schema, but I don't know for sure (don't use it).
Cheers,
barneyb
> -----Original Message-----
> From: brobborb [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 07, 2004 1:49 PM
> To: CF-Talk
> Subject: Re: Find out table names and fields?
>
> how do i dump the results to display on the page? Will this
> only work for mySQL, or for MS SQL as well?
>
> thanks!
> ----- Original Message -----
> From: Barney Boisvert
> To: CF-Talk
> Sent: Wednesday, July 07, 2004 3:42 PM
> Subject: RE: Find out table names and fields?
>
>
> Sure, run these queries, and dump the result.
>
> `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]
