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 vote275 views2 answers
How to take recent row without limit in mysql
SQL
-2 votes243 views1 answer
How to open database
SQL
0 vote261 views2 answers
How to delete the rows with null values in mysql
SQL
5 votes263 views1 answer
Ora-00054 find lock
SQL
0 vote258 views1 answer
Product of a column in mysql
SQL
0 vote254 views1 answer
TSQL function split string
SQL
2 votes263 views6 answers
In operator in sql
SQL
0 vote427 views1 answer
Multiple row join
SQL
0 vote269 views1 answer
Gcloud sql instance list
SQL
11 votes251 views2 answers
Docker create postgres db
SQL