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,
x
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
Advertisement
Answer
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