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

3 votes207 views5 answers
Sql select
SQL
0 vote185 views1 answer
Mysql persistence.xml
SQL
1 vote171 views1 answer
Postgres check blocking
SQL
1 vote215 views1 answer
Nullif postgresql
SQL
0 vote182 views1 answer
Conda install pymysql "windows"
SQL
0 vote173 views1 answer
Mysql show category once count how many products
SQL
2 votes179 views1 answer
How to search table name in stored procedure in sql server
SQL
-1 vote185 views2 answers
Postgresql get last 10 records
SQL
0 vote172 views1 answer
Object Information
SQL
1 vote173 views1 answer
Update and replace mysql
SQL