Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    12

    Unanswered: MySQL: Table Exists?

    For MYSQL, what's the SQL statement to determine if a Table by a specific name exists?

  2. #2
    Join Date
    Mar 2004
    Posts
    33

    Lightbulb

    hi,

    Try with this simple SQL :

    show tables like 'table_name'


    Regards,

  3. #3
    Join Date
    Dec 2005
    Posts
    12
    Is there a statement where I can receive an answer in a result set?
    Some kind of SELECT statement?

Posting Permissions

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