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

1 vote121 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote99 views1 answer
Oracle list chain steps
SQL
0 vote131 views1 answer
Mysql group by range
SQL
0 vote119 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote117 views1 answer
Null column as zero in mysql
SQL
0 vote131 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote112 views2 answers
Mysql output csv
SQL
0 vote122 views1 answer
Mysql query to select the highest value
SQL
5 votes113 views5 answers
Find max number in sql
SQL
0 vote127 views3 answers
Sql query checker
SQL