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

0 vote336 views1 answer
IIF
SQL
0 vote353 views1 answer
Android sqlite add column if not exists
SQL
0 vote357 views1 answer
Longtext sql
SQL
2 votes377 views2 answers
Calculate percentage in sql
SQL
8 votes373 views3 answers
Postgres connection string
SQL
-1 vote351 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote326 views1 answer
Update top 100 sql
SQL
0 vote369 views2 answers
Mysql update two tables at once
SQL
6 votes384 views3 answers
Psql show columns of table
SQL
1 vote422 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL