1

I'm trying to drop a table constraint using Postbird interface or the following SQL:

alter table devices 
drop constraint FK_473c90a9cf5f18226886e62a3b3

Both way, error is: constraint "fk_473c90a9cf5f18226886e62a3b3" of relation "devices" does not exist

Table structure enter image description here

information_schema.table_constraints enter image description here

Any idea?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
jbernardo
  • 161
  • 1
  • 4
  • 14

1 Answers1

0

here is the answer as per @clamp's reply:

alter table devices 
drop constraint "FK_473c90a9cf5f18226886e62a3b3"
Zaffer
  • 1,290
  • 13
  • 32