nr: #1 dodano: 2016-12-25 15:12
Run the below query to find the list of check constraints in your table, including what they are checking for:
select constraint_name, search_condition
where table_name = 'Your table name'
and constraint_type = 'C' -- To filter Check constraints alone
Copy the name of the relevant constraint and paste it in the
Alter table drop constraint command.
Alter Table Your_table_name
Drop Constraint constraint_name; -- Replace constraint_name from above query result