79107468

Date: 2024-10-20 15:57:59
Score: 0.5
Natty:
Report link

Thanks Martin Smith, the answer was that my "apparently" system named constraints were not system_named anymore.

They had been recreated at some stage re-using the default constraint names initially system generated.

SELECT name, DC.is_system_named FROM sys.default_constraints DC WHERE name LIKE '%[__][0-9A-F][0-9A-F][0-9A-F][0-9A-F]%'

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • No code block (0.5):
  • Self-answer (0.5):
  • High reputation (-1):
Posted by: Eric Mamet