1
kudos
spam Kudos Remove

Autogenerated SQL constraint names - why to avoid them | AdaTheDev

published 703 days, 8 hours, 47 minutes ago posted by AdaTheDevAdaTheDev 709 days, 15 hours, 18 minutes ago
Saturday, March 06, 2010 5:31:56 AM GMT Saturday, February 27, 2010 11:00:57 PM GMT

Autogenerated constraint names in SQL Server - are they convenient, or are they a hindrance? For me, they are a hindrance. Why should I care that SQL Server autogenerates a constraint name when I don't explicitly specify one? Why does it matter if it names my PRIMARY KEY constraint "PKConstrai3214EC271FCDBCEB", or my DEFAULT constraint "DFConstraintColumnA__21B6055D"? This article explains reasons why you should specify a name yourself for each constraint.

category: Management | clicked: 1 | | source: www.adathedev.co.uk | show counter code
tags: sqlserver database

No comments yet, be the first one to post comment.

To post your comment please login or signup