var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Remove default value from a table
I cannot figure this out, please help.
I have a table with an attribute with a default value. How do I erase this default value (with sql). I do not want to lose any data in my table.
I didn't get that to work, it said I should use ALTER TABLE DROP CONSTRAINT. I have tried that before but without success.
But after a few minutes (almost an hour) I found a way to solve it:
ALTER TABLE voucher DROP CONSTRAINT DF__voucher__voucher__56D3D912;
The Constraint name I found by looking in the sysobjects table.
just do an alter table ... alter column ... and omit the default.