sql queries to expose its meta data. i.e.
select * from information_schema.columns
where table_name = 'mytablename'
and the like
s. isaac dealey 214.823.9345
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
> 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]
