Programmatically set default value to function? 1

[cheyney]

Hey,

I'm remotely running MSDE and i forgot to set the default value on a table column. How do I set it programmatically?

I've tried this code:

ALTER TABLE tblInventory
{
Alter Column QtyOnHndID
{
set DEFAULT newid()
}
}
go


but i get the folling error:

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation


any ideas?

cheyney

 

[swampBoogie]

According to BOL the following should be valid

alter table tblInventory
add constraint QtyOnHndIDDefault
default newid()
for QtyOnHndID



ALTER TABLE tblInventory
Alter Column QtyOnHndID
set DEFAULT newid()

is the ANSI SQL syntax, which SQL server does not support.

 

[cheyney]

awesome, thanks...don't know why i couldn't find that

cheyney