Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Malaysia
    Posts
    3

    Unanswered: How to get all the table names from my database?

    Hello Guys,
    I used to get all the table name in ORACLE database by using the following statment:

    SELECT * FROM TAB;

    But I don't know how to do it in MySQL database. I tried to use the same statment but unfortunately I am getting an error.
    So anyone can tell me how can I get the table names from MySQL database?


    Regards
    Bassam

  2. #2
    Join Date
    Mar 2004
    Posts
    1
    Use Show tables;
    But u must selec the database first in which u want to see the tables

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •