Column default value

[AndrejSlo]

Hi,

i was just wondering if the default value for a column can be set if i only have ("what should be") systables available (i'd like to update destination database to the current state with all the neccesary design modifications and i only have database "snapshot" consisting of all the sys* tables). In sysobjects, there is a row with the appropriate default ID, but default value isn't there. Is there a way to reconstruct it from systables or is it stored only in table definition (which is hmmm , in systables )?
Thanks for your help !

 

[AndrejSlo]

Ok, should have checked syscomments where everything is recorded. Problem solved.