Re: Does Table Exist

[Jon Stephens]

DELIMITER //

CREATE PROCEDURE TableExists (IN name VARCHAR(64), OUT found INT)
  BEGIN
    SELECT (COUNT(*) > 0) INTO found 
    FROM INFORMATION_SCHEMA.TABLES 
    WHERE TABLE_NAME = name;
  END //

DELIMITER ;

CALL TableExists('t1', @foundit);

SELECT @foundit; # 1 if table exists, 0 if not

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle