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 vote233 views1 answer
Creation d'un trigger sql
SQL
0 vote231 views1 answer
How to select even id in sql
SQL
3 votes260 views1 answer
Oracle function return
SQL
0 vote191 views1 answer
Mysql convert column to uppercase
SQL
0 vote232 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote230 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote223 views1 answer
Redirection 301 htaccess nom de domaine
SQL
10 votes235 views2 answers
Linux command line import mysql database
SQL
1 vote239 views1 answer
Check if mysql is installed
SQL
0 vote234 views1 answer
Mysql count with two joins
SQL