How to check if table exists in MySql db?

Checking table existence with dynamic query?

• the usual is >> if exists (select * from db.dbo.sysobjects WHERE name ='tableName') >>begin >>drop.. >>end in this case, the table I want to check and drop is created using dynamic sql, so we dont know the eaxct name (can vary). This is what I want to do in pic, >>declare @sql varchar(100) >>declare @no float >>set @no=5 --------------------------------------… >> if exists (select * from db.dbo.sysobjects WHERE name ='tableName' + @no) >>--condition OR >>select @sql= 'if exists (select * from db.dbo.sysobjects WHERE name =''tableName''+@no+')' >>exec (@sql) etc.. None of them work, How can I do something like that?

• Answer:

  use a table variable or a temp table to load the information about the table names or ensure the table name is populated before the if exists statement gets executed. You need to ensure that the value gets populated before the statement is executed. Use the syntax something like this set @SQL = 'if exists (select * from db.dbo.sysobjects WHERE name ='+@tableName+')' exec (@sql)