Thanks Adam and Barry for your answers.

i tried both your approaches.

Adam's method worked for me.

but one more point here is, when i tried using "sys.default_constraints" i got an...

my implementation script is as follows

IF NOT EXISTS(SELECT 1

FROM sysobjects,

syscolumns

WHERE sysobjects.id = syscolumns.id

AND sysobjects.name = 'Morningstarcategory'

AND syscolumns.name = 'LastUpdated')

BEGIN

EXECUTE ('ALTER TABLE Morningstarcategory

ADD LastUpdated DateTime null

DEFAULT (getdate())')

END

i...

the code generated in the SSMS window is same as i wrote.

my problem is as follows.

1. i write a script to make schema changes in a DB

2. i have to...