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 votes181 views1 answer
How to find constraints on a table in oracle
SQL
-1 vote189 views1 answer
Export mysql table to file
SQL
19 votes192 views3 answers
How to change column type psql
SQL
0 vote211 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
12 votes183 views4 answers
Import mysql database command line linux
SQL
16 votes238 views3 answers
Order by sql query
SQL
13 votes206 views2 answers
Sql online compiler
SQL
0 vote262 views2 answers
How to prevent sql injection in java
SQL
1 vote372 views1 answer
Postgres upgrade to superuser
SQL
0 vote297 views1 answer
Insensitive case match sqlalchemy
SQL