oracle alter table delete column

Xenophobic Xenomorph answered on April 21, 2021 Popularity 10/10 Helpfulness 8/10

answer oracle alter table delete column

related oracle drop column

oracle alter table delete column

Comment

alter table table_name drop column column_name;
alter table table_name drop (column_name1, column_name2);

Popularity 10/10 Helpfulness 8/10 Language sql

Source: oracle-base.com

Tags: alter-table oracle sql

Link to this answer
Share Copy Link

Contributed on Apr 21 2021

Xenophobic Xenomorph

0 Answers Avg Quality 2/10

Closely Related Answers

oracle drop column

Comment

ALTER TABLE my_table DROP COLUMN my_col;
-- To check if column exists before renaming it:
DECLARE
    l_cnt INTEGER;
BEGIN
    SELECT count(*) INTO l_cnt
    FROM dba_tab_columns		-- or all_tab_columns (depending on grants)
    WHERE owner = 'my_schema' AND table_name = 'my_table' 
    	AND column_name = 'my_col';
    IF (l_cnt = 1) THEN
        EXECUTE IMMEDIATE 'ALTER TABLE my_schema.my_table DROP COLUMN my_col';
    END IF;
END;

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: drop

Link to this answer
Share Copy Link

Contributed on May 04 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle alter table delete column

Contents

More Related Answers

oracle alter table delete column

Closely Related Answers

oracle drop column

Grepper

Documentation

Social

Legal

Contact

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