Breaking News: Grepper is joining You.com. Read the official announcement!

drop table if exists oracle

Add Answer

VasteMonde answered on March 19, 2021 Popularity 9/10 Helpfulness 6/10

answer drop table if exists oracle

related oracle sql drop column if exists

related oracle drop table if exists

drop table if exists oracle

Comment

DECLARE
    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, [...]);

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: drop-table exists oracle sql

Link to this answer
Share Copy Link

Contributed on Aug 27 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

oracle sql drop column if exists

Comment

DECLARE
  l_cnt NUMBER;
BEGIN
  SELECT COUNT(*) INTO l_cnt 
    FROM dba_tab_columns
   WHERE owner = 'my_owner'
     AND table_name = 'my_table' AND column_name = 'my_column';
  IF( l_cnt = 1 ) THEN
    EXECUTE IMMEDIATE 'ALTER TABLE my_table DROP COLUMN my_column';
  END IF;
END;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: exists ex

Link to this answer
Share Copy Link

Contributed on Mar 19 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle drop table if exists

Comment

DECLARE
  table_exists NUMBER := 0;
BEGIN
  -- Check if the table exists
  SELECT COUNT(*) INTO table_exists
  FROM user_tables
  WHERE table_name = 'YOUR_TABLE_NAME';

  -- Drop the table if it exists
  IF table_exists > 0 THEN
    EXECUTE IMMEDIATE 'DROP TABLE YOUR_TABLE_NAME';
    DBMS_OUTPUT.PUT_LINE('Table dropped successfully.');
  ELSE
    DBMS_OUTPUT.PUT_LINE('Table does not exist.');
  END IF;
END;
/

Popularity 6/10 Helpfulness 3/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

drop table if exists oracle

Contents

More Related Answers

drop table if exists oracle

Closely Related Answers

oracle sql drop column if exists

oracle drop table if exists

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.