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

9 votes219 views5 answers
Laravel to sql
SQL
0 vote192 views1 answer
What is the essence of SQL?
SQL
1 vote212 views1 answer
Print all records of table in mysql
SQL
0 vote212 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote215 views1 answer
Mysql récupérer le code création de vue
SQL
16 votes199 views6 answers
Insert sql
SQL
0 vote217 views2 answers
Identity syntax in sql
SQL
1 vote218 views1 answer
Too many connections mysql
SQL
0 vote193 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
1 vote165 views1 answer
Alter user mysql native password
SQL