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

1 vote119 views1 answer
Is sql fast
SQL
1 vote108 views1 answer
Sql pick random row
SQL
0 vote149 views1 answer
Order by number of character in sql
SQL
2 votes144 views1 answer
Db.relationship sqlalchemy flask
SQL
1 vote108 views1 answer
Postgresql reset serial counter after deleting content
SQL
1 vote110 views1 answer
Mysql remove last empty newline
SQL
-1 vote109 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote105 views1 answer
Teller stamp , bmo , PDF
SQL
1 vote113 views1 answer
How to remove identity from a column in sql server
SQL
1 vote108 views1 answer
Mysql random limit 1
SQL