SQL CONSTRAINT another name

I have two databases with exactly the same table, but they are different with respect to CONSTRAINT. See below for more details.

enter image description here

As you can see, SRO_VT_SHARD_188has CONSTRAINT for _RefObjChar, but SRO_VT_SHARD_D9does not have it.

I deleted a table _RefObjCharin SRO_VT_SHARD_D9and recreated it with a query that has a full CONSTRAINT, but I get this error:

There is already an object in the database with the name "DF__RefObjChar_Resist27".

I know that if I change the name CONSTRAINT to DF__RefObjChar_Resist27AAA, my request may work without errors, but I was wondering if I would do it, would it make any request error or something would not work because the name of the old CONSTRAINT had changed?

+4

Source: https://habr.com/ru/post/1662712/


All Articles