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 vote159 views1 answer
Truncate table in postgresql and reset id
SQL
15 votes111 views6 answers
Laravel db transaction
SQL
4 votes145 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote107 views1 answer
Joins vs includes
SQL
0 vote96 views4 answers
Forenkey code alchemy sql
SQL
22 votes101 views3 answers
Join three tables sql
SQL
8 votes116 views1 answer
Mysql restore database
SQL
0 vote119 views1 answer
Systems sql
SQL
1 vote97 views1 answer
Trigger in postgresql to change incoming entry
SQL
2 votes98 views1 answer
Mysql sql add created updated timestamp to existing table
SQL