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 vote143 views1 answer
Mysql use password error
SQL
-1 vote164 views1 answer
Spring boot mysql connection properties
SQL
0 vote173 views1 answer
Excel vba import data to sql server
SQL
5 votes148 views1 answer
Minecraft java port number
SQL
1 vote158 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote148 views1 answer
Mysql read row
SQL
-1 vote163 views2 answers
Import data from excel to sql server automatically
SQL
0 vote158 views2 answers
Identity column in sql server
SQL
5 votes147 views1 answer
Alter table add comment oracle
SQL
103 votes1.9K views1 answer
Like sql
SQL