Remove _sql_constraints

Question

I want to remove _sql_constraints.

For example in account_invoice.py there is a constraints on number field. Now I want to remove it.

Can anyone have idea how to deal with it?

Thank you.

Answer 1

You can remove your constraint using following query.

SELECT *
FROM information_schema.constraint_table_usage
WHERE table_name = 'account_invoice';

ALTER TABLE account_invoice DROP CONSTRAINT account_invoice_number_uniq;