jvervloet's Journal: Changing default value for MS-SQL column

I needed to add a default value to a column in an M$ SQL database. It was not trivial to find, but here is the query:

alter table table_name add default default_value for column_name

changing default values

[jvervloet]

When default values are added this way, it is not easy to change them. In fact, I did not manage to change them. So I posted a message [google.be] on comp.databases.ms-sqlserver [google.be] , and there is some useful information in this thread.