Does Table Exist

[John Noble]

Hi folks,

Im trying to write a SP to detect if a table exists or not.

Here is my effort...

CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_DoesTableExist`(
IN p_tableName varchar(100)
)
BEGIN

SHOW TABLES LIKE p_tableName;


END

The LIKE statement only seems to accept a literal string and not a parameter. Any ideas ??

J