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 vote153 views1 answer
Raise application error in oracle
SQL
1 vote137 views1 answer
Sql select all from one table and one column from another
SQL
10 votes117 views2 answers
Sql where clause multiple values
SQL
8 votes141 views1 answer
Today minus 15 days postgresql
SQL
0 vote235 views1 answer
ORA-00942
SQL
7 votes273 views2 answers
Drop index oracle
SQL
0 vote141 views1 answer
Postgresql stored procedure update table values
SQL
0 vote663 views1 answer
Sql show table name in result
SQL
0 vote192 views1 answer
Creating sqeuence in oracle database
SQL
0 vote141 views1 answer
Ms Sql set us timezone
SQL