1ALTER TABLE my_table DROP COLUMN my_col;
2-- To check if column exists before renaming it:
3DECLARE
4 l_cnt INTEGER;
5BEGIN
6 SELECT count(*) INTO l_cnt
7 FROM dba_tab_columns -- or all_tab_columns (depending on grants)
8 WHERE owner = 'my_schema' AND table_name = 'my_table'
9 AND column_name = 'my_col';
10 IF (l_cnt = 1) THEN
11 EXECUTE IMMEDIATE 'ALTER TABLE my_schema.my_table DROP COLUMN my_col';
12 END IF;
13END;
1alter table table_name drop column column_name;
2alter table table_name drop (column_name1, column_name2);