SQL Server : table is deleted by primary key is not from sys.objects

151 Views Asked by At

We have been publishing database through SSDT. Facing one very strange error. It has dropped the table but primary key of that table is not deleted which is not letting new table be created with the same table & primary key name.

Our SQL Server addition does not allow DAC login it update the sys.objects table. I have attached screenshot where table name is blank .

enter image description here

  1. How this can be corrected?

  2. How this constraint can be deleted?

  3. Why such abnormal behavior?

0

There are 0 best solutions below