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

0 vote153 views1 answer
Sqlalchemy existing database
SQL
40 votes263 views4 answers
PostgreSQL add column
SQL
12 votes204 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote199 views1 answer
Mysql 8 error on identified by
SQL
1 vote178 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
4 votes185 views1 answer
Oracle delete last row
SQL
0 vote183 views1 answer
Pgsql is not permitted to log in
SQL
-1 vote187 views1 answer
Auto increment psql not primary key
SQL
0 vote185 views1 answer
Group by two columns postgres
SQL
0 vote179 views2 answers
Select limit ms sql
SQL