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 votes214 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote190 views1 answer
Version and edition of SQL Server Database Engine
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote190 views1 answer
Mssql current date
SQL
0 vote192 views2 answers
Disallowed function mysql to_date()
SQL
1 vote234 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote198 views1 answer
Java nosql sort
SQL
2 votes246 views2 answers
Mysql search for column name in all tables
SQL
16 votes189 views4 answers
Ascending order mysql
SQL
0 vote270 views1 answer
Insert into table with only identity column
SQL