Drop table if exists test

DECLARE								-- Oracle
    existing_table number;			
BEGIN
    SELECT count(*) into existing_table FROM ALL_TABLES
    WHERE TABLE_NAME = 'table_name' AND OWNER = 'owner';
    IF existing_table = 1 then
        EXECUTE IMMEDIATE 'DROP TABLE owner.table_name';
    END IF;
END;
/
CREATE TABLE owner.table_name (BDAY DATE, [...]);

If table exists drop

IF EXISTS(SELECT *
          FROM   dbo.Scores)
  DROP TABLE dbo.Scores

Source: stackoverflow.com

Similar codes

5 votes163 views1 answer
Oracle find foreign key dependencies
SQL
0 vote187 views1 answer
Database db connection string format
SQL
4 votes171 views1 answer
Delete record mysql query
SQL
0 vote200 views1 answer
Sql query inline if
SQL
0 vote179 views1 answer
How to change mysql port in xampp
SQL
0 vote172 views1 answer
Sql select by content lenght
SQL
0 vote183 views1 answer
Pgadmin save data greyed out
SQL
-1 vote142 views2 answers
On delete set default sql server
SQL
36 votes228 views6 answers
Change column data type sql
SQL
2 votes157 views3 answers
How to get second highest salary in each department in sql
SQL