I suppose in all databases. (Access, MySQL, MS SQL are what I use most
often.) Ben answered for SQL. (thank you)

I'm thinking of setting up a little app to be able to administer my
databases remotely.

The basic is to be able to see the tables (show tables) and the fields
within (describe [table]).

Too many ISPs I'm looking at want the user to install phpmyadmin and the
like.
I just got frustrated and felt that if I'm going to have that trouble I
might as well solve the problem once and for all.

Gil Midonnet

  -----Original Message-----
  From: Steve Nelson [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, March 24, 2004 4:15 PM
  To: CF-Talk
  Subject: RE: show tables in cold fusion

  What database? In SQL it's sp_tables. then you could cfdump it in CF.

  Steve Nelson
    -----Original Message-----
    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]

Reply via email to