sql - Unable to drop default constraint in oracle. Tried the below code but doesn't work -
sql> alter table customers modify age int default 10; table altered. sql > alter table customers alter column age drop default; error @ line 2: ora - 01735 : invalid alter table option. you alter statement wrong , cannot use 2 alter command in 1 statement. , never drop default value instead set null . if column has default value, can use default clause change default null, cannot remove default value completely. if column has ever had default value assigned it, data_default column of user_tab_columns data dictionary view display either default value or null. alter table use following sql command drop default. alter table constomers modify age default null;
