drop all constraints

To drop all constraints on a table "sampleTable", use the following commands:

CREATE TABLE temp AS SELECT * FROM sampleTable;
DROP TABLE sampleTable;
CREATE TABLE sampleTable AS SELECT * FROM temp;
DROP TABLE temp;

source
reference