lundi 2 décembre 2019

Postgresql: DROP CONSTRAINT IF EXISTS not working

I want to delete a constraint only if it exists. But it's not working or I do something wrong.

Here is my query:

IF EXISTS (SELECT * FROM information_schema.table_constraints WHERE constraint_name='res_partner_bank_unique_number')
THEN ALTER TABLE res_partner_bank DROP CONSTRAINT res_partner_bank_unique_number;

It gives me this error:

ERROR: syntax error at or near "IF"

If anybody can help me please. Thanks.

Regards.

Aucun commentaire:

Enregistrer un commentaire