"Jonathan Psaila-Depasquale" wrote:

> Hi,
>
> You have to do it in two commands and anyway the command is actually
> ALTER TABLE. So try the following:
>
>
> alter table mydb.dbo.mytable
> alter column paymentdate smalldatetime not null
>
> alter table mydb.dbo.mytable
> add constraint paymentdate_def default getdate() for paymentdate
>
>
> Jonathan
>
>
>
> Ryan wrote:
> > Currently, PaymentDate in my table is a SMALLDATETIME and NULL is allowed. I
> > would like to alter PaymentDate column to be NOT NULL and set its default
> > value to current date.
> > I am using the following osql command but it generated an error; could
> > someone please help?
> >
> > ALTER COLUMN PaymentDate NOT NULL DEFAULT GETDATE();