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 vote200 views1 answer
How to export only procedures mysql
SQL
3 votes202 views1 answer
Postgres kill running query
SQL
15 votes187 views3 answers
Create table with primary key auto increment in sql
SQL
2 votes217 views1 answer
Oracle run_duration to number
SQL
0 vote188 views1 answer
Drush run sql select
SQL
1 vote204 views1 answer
Snowflake rename column name
SQL
6 votes207 views2 answers
What is non relational database
SQL
0 vote180 views1 answer
Backup a table in sql
SQL
4 votes201 views5 answers
Primary key
SQL
9 votes185 views1 answer
Identity insert on sql server
SQL