“DROP TABLE IF EXISTS” in Oracle and SQL Server

SQL
 

 
 
 
  
In MySQL it is pretty easy to drop a table if it exists already. In Oracle and Microsoft’s SQL
MySQL:
 
   
DROP TABLE IF EXISTS [table_name]
 
   
Oracle:
 
   
BEGIN EXECUTE IMMEDIATE 'DROP TABLE [table_name]'; EXCEPTION WHEN OTHERS THEN NULL; END;
 
   
SQL
 
   
IF EXISTS ( SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '[table_name]') DROP TABLE [table_name]