Oracle drop column

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;

Oracle alter table delete column

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

Source: oracle-base.com

Similar codes

0 vote214 views2 answers
How to type a blank discord messgae
SQL
0 vote179 views1 answer
Oracle table free space
SQL
2 votes183 views2 answers
Sql lag
SQL
2 votes240 views1 answer
Creating a view SQL
SQL
3 votes198 views1 answer
Ms sql skip take
SQL
0 vote177 views3 answers
Drop multiple columns in sql
SQL
53 votes541 views6 answers
Sql server alter column
SQL
1 vote160 views1 answer
Floor function in sql oracle
SQL
13 votes183 views5 answers
Sql default
SQL
0 vote187 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL