alter column table and make default value to empty string

Question

good day.. just want to ask, is it possible to alter a column table and make the default value to empty string..

i tried using this query,

    Alter Table Employee Alter Column sJobTitle Varchar(200) DEFAULT '' 

Unfortunately, it doesn't work..

Please let me know, if 'm doing it correct..

Thanks,

Link

Answer 1

You need to add a contraint. Referring to http://blog.sqlauthority.com/2008/05/31/sql-server-create-default-constraint-over-table-column/

ALTER TABLE Employee 
        ADD CONSTRAINT DF_Employee _JobTitle
        DEFAULT '' FOR sJobTitle 

Answer 2

try this query. this query does not change current datas to default.

ALTER TABLE Employee
ADD DEFAULT ('') FOR sJobTitle 

maybe it work.