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 vote343 views1 answer
Alter table name including schema
SQL
0 vote240 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote202 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
15 votes207 views2 answers
Select where duplicate mysql
SQL
0 vote198 views1 answer
How to add boolean column in postgresql
SQL
0 vote198 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote222 views1 answer
.sql File Run in PSQL
SQL
0 vote201 views1 answer
Sql dmv to capture updates
SQL
1 vote229 views1 answer
Mysql select all and rename one
SQL
0 vote309 views1 answer
Mysql edit trigger
SQL