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

1 vote300 views1 answer
How to delete record sql delphi
SQL
0 vote342 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote309 views1 answer
Postgresql update to unique
SQL
5 votes349 views6 answers
In operator sql
SQL
0 vote383 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
3 votes344 views1 answer
Increment integer in table sql
SQL
1 vote322 views2 answers
Datetrunc hour snowflake
SQL
0 vote319 views1 answer
Login failed for login due to trigger execution
SQL
0 vote317 views4 answers
How to drop all tables in sql
SQL
5 votes305 views6 answers
Sql add days to date
SQL