SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

Autogenerated SQL constraint names - why to avoid them | AdaTheDev

published 809 days, 4 hours, 10 minutes ago posted by

AdaTheDev 815 days, 10 hours, 41 minutes ago

Autogenerated SQL constraint names - why to avoid them | AdaTheDev

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

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

Autogenerated SQL constraint names - why to avoid them | AdaTheDev

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

Open ID Login

Standard Login

Forgot Password?

Sign up