Error!
Success!

Autogenerated SQL constraint names - why to avoid them

0
kicks

Autogenerated SQL constraint names - why to avoid them  (Unpublished)

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 "PK__Constrai__3214EC271FCDBCEB", or my DEFAULT constraint "DF__Constraint__ColumnA__21B6055D"? This article explains reasons why you should specify a name yourself for each constraint.


Kicked By:
Drop Kicked By: