Developing Matt

What is the default value on my column?  (Take out the criterion for a broader result set)

FROM col.name as col,   defaultvalue = c.text
FROM syscomments c
JOIN
     (SELECT name, cdefault 
      FROM syscolumns
      WHERE id = object_id(‘MYTABLE’)
                  and name = ‘MYCOLUMN’
                  AND cdefault > 0
     )  col on c.id = col.cdefault

How do you modify the default value on my column?  I didn’t know, but it is actually a constraint.  So it is a drop and a re-create for a constraint.

ALTER TABLE [dbo].[MYTABLE] drop  CONSTRAINT [MYCONSTRAINT]

ALTER TABLE [dbo].[MYTABLE] ADD  CONSTRAINT [CONSTRAINT]  DEFAULT (‘MYDEFAULTVALUE’) FOR [MYCOLUMN]‘