Question

oracle 如何用sql删除非空约束?

Answer 1

SELECT CONSTRAINT_NAME,COLUMN_NAME FROM DBA_CONS_COLUMNS WHERE TABLE_NAME=表名;
alter table 表名 drop constraint 上条语句查询出的CONSTRAINT_NAME;