Justin,
I am using MS SQL 7 and I want to do it remotely using cf page. Thanks.
Nathan
JustinMacCarthy wrote:
> What DB nathan ???
>
> In MsSql you can use a StoredProc called sp_tables witch will return all
> the tables in a DB including the sys tables
>
> In Access you can get at the table names from a systable but I can remember
> which one... hold on it's called MsysObjects ,but it has alot of other stuff
> in there. To view the table in access go to tools->options->view and tick
> hidden objects and system objects
>
> or use ado (search for ADO in the Allaire Forums)
>
> ~JustinMacCarthy
>
> ----- Original Message -----
> From: "Nathan Chen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, September 23, 2000 1:09 AM
> Subject: display a list of table names
>
> > Hi everyone,
> >
> > For some reason I remember there is a CF tag that allows to display all
> > the table names in a database. Is there a such tag or is just my
> > imagination?
> >
> > Nathan Chen
> > --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> >
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
