Drop table if exists

[fake01]

I was just wondering how I would go about dropping a table if it exists. I don't have much knowledge of MySQL and have been using PHPMyAdmin to create, insert, edit, delete and drop tables.

But I'm currently creating a .sql script which will create and insert all the default tables and data and want to drop tables if they already exist. So how will I achieve this?

 

[diabolo]

simple.

DROP TABLE IF EXISTS `Table_I_Want_To_Drop`

 

[fake01]

Cheers

But is it:

DROP TABLE IF EXISTS `Table_I_Want_To_Drop`

or

DROP TABLE IF EXISTS Table_I_Want_To_Drop;

Or can both be used?

 

[diabolo]

both can be used.
I just like to use `` to refer to table names