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 vote171 views1 answer
Check user sql password from command line
SQL
1 vote109 views1 answer
Select from describe sql
SQL
0 vote109 views1 answer
How to join result table in mysql
SQL
27 votes104 views5 answers
Add column in table
SQL
0 vote111 views1 answer
Mysql backup certain tables workbench
SQL
5 votes104 views1 answer
Oracle find foreign key dependencies
SQL
0 vote95 views1 answer
Import mysql'
SQL
3 votes63 views4 answers
Mysql delete duplicate rows
SQL
0 vote138 views1 answer
Tsql cte in a transaction
SQL
1 vote110 views2 answers
Mysql extract month
SQL