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 vote118 views1 answer
Check if a word appears at the end sql query
SQL
0 vote152 views1 answer
How do I insert a blob in SQL?
SQL
5 votes134 views3 answers
Mysql remove unique constraint
SQL
4 votes119 views1 answer
Oracle session date format
SQL
0 vote167 views1 answer
SQL-Arten
SQL
0 vote167 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote156 views5 answers
Right join
SQL
1 vote131 views1 answer
What is a Database?
SQL
1 vote159 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote154 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL