在CREATE TABLE命令中创建了没有约束名的检查约束,是否可能删除该约束?
select constraint_name, search_condition
from user_constraints
where table_name = 'Your table name'
and constraint_type = 'C' -- To filter Check constraints alone
复制相关约束的名称,并将其粘贴到Alter table drop constraint
命令中。
Alter Table Your_table_name
Drop Constraint constraint_name; -- Replace constraint_name from above query result