ALTER TABLE question

[Corporal Agarn]

SQL Server 2008R2. Do all defaults need a constraint name? Why would you or would you not use a constraint name? Example of a SSMS created table script:

ALTER TABLE [dbo].[MyTable] ADD CONSTRAINT [DF_MyTable_MyDateColumn] DEFAULT (getdate()) FOR [MyDateColumn]
GO

ALTER TABLE [dbo].[MyTable] ADD DEFAULT ((0)) FOR [MyBitColumn]
GO

Thanks

[Simon_Whale]

From what I read on table constraints[^] It's to maintain backwards compatibility.

Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON

[Corporal Agarn]

Thank you! As I have a tendensy to skim the definitions I miss things.

[Lost User]

It's always a good idea to use constraint names. Makes it easy to disable/drop a constraint.