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 vote156 views1 answer
This week mysql
SQL
1 vote207 views1 answer
Adding a check statement in sql
SQL
1 vote130 views4 answers
Fatal database postgres does not exist
SQL
4 votes150 views2 answers
DB::transaction
SQL
7 votes148 views4 answers
Database dump mysql command
SQL
0 vote163 views1 answer
Insert output identity
SQL
0 vote136 views1 answer
Populate db from command line postgres
SQL
25 votes123 views1 answer
Mysql grant all privileges to a user
SQL
0 vote157 views2 answers
Mysql add days to date
SQL
2 votes144 views1 answer
How to check grants on a package in oracle
SQL