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 votes160 views1 answer
Modify column name in tsql
SQL
1 vote152 views1 answer
Convert rows to string sql server
SQL
1 vote238 views1 answer
Oracle create program if not exists
SQL
0 vote155 views1 answer
Mysql bash execute sql file
SQL
0 vote190 views1 answer
Sparql if bound query
SQL
0 vote174 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote188 views2 answers
Install sql server management studio ubuntu
SQL
0 vote163 views1 answer
Sql on-premises
SQL
0 vote158 views3 answers
Group_concat sql server
SQL
0 vote229 views1 answer
Sqlite display headers on columns
SQL