Journal jvervloet's Journal: Changing default value for MS-SQL column 1
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 (Score:1)
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.