#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    12
    Rep Power
    0
    I'm trying, through an SQL statement, to retrieve table names and column names from a selected database.

    Something like...

    **PSUEDO CODE**

    GET all_table_names FROM $db

    ->returns(table1, table2, table3, table4)

    **PSUEDO CODE**


    Is there a way of doing this?

    Thanks,

    Terry Scott
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 1999
    Posts
    114
    Rep Power
    16
    MySQL has a

    show tables;

    statement.

Similar Threads

  1. are table names in hidden fields wise?
    By arrival5 in forum PHP Development
    Replies: 4
    Last Post: February 14th, 2004, 09:31 AM
  2. Replies: 3
    Last Post: February 11th, 2004, 08:30 AM
  3. domain names in database.....
    By RyanN in forum MS SQL Development
    Replies: 0
    Last Post: February 10th, 2004, 02:31 PM
  4. League table problem
    By silverduck in forum MySQL Help
    Replies: 8
    Last Post: February 10th, 2004, 12:38 PM
  5. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 06:19 PM

IMN logo majestic logo threadwatch logo seochat tools logo