how to set the default value to the field in a sql table

Feb 8 2011 12:33 AM

hi,
can anyone help me,is it able to set the default value as null to the field in a table.by using this query
ALTER
TABLE register
ALTER
column functionalarea SET DEFAULT 'NULL'
i got a error in this query also.can anyone rectify it.
thank you

Answers (3)