Alter using osql

[Ryan]

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();

[Jonathan Psaila-Depasquale]

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

Post by Ryan
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();

[Ryan]

Thanks, it worked.

Post by Jonathan Psaila-Depasquale
Hi,
You have to do it in two commands and anyway the command is actually
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

Post by Ryan
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();