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

2 votes163 views1 answer
Merge two columns in sql oracle
SQL
1 vote140 views1 answer
Mysql month name extract
SQL
1 vote144 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote174 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote193 views2 answers
Wordpress change url in database
SQL
4 votes138 views2 answers
Oracle sql group by date year
SQL
1 vote116 views1 answer
Mysql datetime with timezone offset
SQL
0 vote111 views1 answer
Clear query cache sql server
SQL
4 votes137 views5 answers
Primary key
SQL
13 votes125 views5 answers
Oracle list tables
SQL