Drop a table

[cfmartin2000]

Is it possible to use an IF statement to drop a table if it exists and skip it otherwise?

I am trying to get this (pseudo-code):

IF(istable(table1)) then DROP table1 else do nothing

Thanks in advance.

 

[TonyGroves]

Sure:
[tt]
DROP TABLE IF EXISTS tbl
[/tt]

 

[cfmartin2000]

Thanks. I'm not an idiot but I feel like on in seeing how easy that is.