oracle sql drop column if exists

Solutions on MaxInterview for oracle sql drop column if exists by the best coders in the world

Search
showing results for - "oracle sql drop column if exists"
Ian
25 Mar 2016
1DECLARE
2  l_cnt NUMBER;
3BEGIN
4  SELECT COUNT(*) INTO l_cnt 
5    FROM dba_tab_columns
6   WHERE owner = 'my_owner'
7     AND table_name = 'my_table' AND column_name = 'my_column';
8  IF( l_cnt = 1 ) THEN
9    EXECUTE IMMEDIATE 'ALTER TABLE my_table DROP COLUMN my_column';
10  END IF;
11END;
similar questions
oracle drop type if existsdelete all table oracledrop primary key oracleoracle drop temporary tableoracle drop job if existsoracle drop sequence if existsdelete rows table oraclepl sql delete from tableoracle drop typedrop table if existsdelete column from table oracle pl sqloracle sql drop tableoracle rename column if existsoracle sql drop table purgeoracle drop index if existsdrop table if exists oraclesql drop table if existsdrop column if exists sql serveroracle drop default valueoracle drop all schema tablesoracle drop columnoracle drop constraintoracle drop rulestable drop if exist sql serverhow to remove tablespace in oracledrop colum oracle 18c
queries leading to this page
drop table if exists oracleoracle drop table if not existsdrop table if exists sql oracledrop column if exists oracleoracle drop column if existsdrop column id in oracleoracle sql drop table if existsoracle drop table if existsoracle sql drop column if existsoracle sql drop column if exists