ALTER COLUMN

Hi all,
I am trying to alter a column with the following statement.
Can anyone help me get the syntax correct..
ALTER TABLE asmt_v1_question_passed ALTER COLUMN pass_dt SET DEFAULT
getdate()
Cheers,
AdamTry
ALTER TABLE dbo.asmt_v1_question_passed ADD CONSTRAINT
DF_C_Name DEFAULT CURRENT_TIMESTAM FOR pass_dt
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Adam Knight" <dev@.brightidea.com.au> wrote in message
news:ugFl8Qs2FHA.3272@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I am trying to alter a column with the following statement.
> Can anyone help me get the syntax correct..
> ALTER TABLE asmt_v1_question_passed ALTER COLUMN pass_dt SET DEFAULT
> getdate()
> Cheers,
> Adam
>|||Hi Adam ,
I think it can be a solution for your problem :
ALTER TABLE asmt_v1_question_passed WITH NOCHECK ADD
DEFAULT getdate() FOR [pass_dt]
"Adam Knight" wrote:

> Hi all,
> I am trying to alter a column with the following statement.
> Can anyone help me get the syntax correct..
> ALTER TABLE asmt_v1_question_passed ALTER COLUMN pass_dt SET DEFAULT
> getdate()
> Cheers,
> Adam
>
>