changing the default value

Hi,
I am facing a problem. Our current database aontains more than 50 tables
having a datefield, whose default value is set as 'GetUTCDate()'. Now what i
need is a Query to replace those default value with GetDate() without any
dataloss. We dont care abt the time differrence.
Thanking u in advance
regards
LaraLara
Drop constraint and create a new one
"Lara" <lara@.hotmail.com> wrote in message
news:OoiUym$lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am facing a problem. Our current database aontains more than 50 tables
> having a datefield, whose default value is set as 'GetUTCDate()'. Now what
> i
> need is a Query to replace those default value with GetDate() without any
> dataloss. We dont care abt the time differrence.
> Thanking u in advance
> regards
> Lara
>