Kosha5,

I do understand that the constraint is on the column not the row, but what I was wondering is if I have four columns, c1,c2,c3, and c4 and then I add c5 as lets say as a nvarchar(25) field with a default constraint of 'This is an example', in the article, that default constraint doesn't populate in the metadata until I would go and update a column for row. So example, I want to update the top 10 rows and set c1 = 1. At that point, does the engine then update c5 with the value 'This is an example' so now it is stored in all of the metadata as well? If so, my only question really was that yeah, who would do such a thing to have a large default constraint, but maybe it's a default constraint using the newid() to generate a guid...so does that incur any additional overhead since not only is the value for c1 being updated, but also c5?