[RESOLVED] Removing the Deafult Value from a SQL Server 2005 Column

[jmcilhinney]

No-one here at work has ever had to perform this specific task before so no-one can tell me how they did it. I've read the documentation for the ALTER TABLE statement in Books Online and the syntax starts like this:

ALTER TABLE table_name
{ [ ALTER COLUMN column_name 
   {DROP DEFAULT 
   | SET DEFAULT constant_expression 
   | IDENTITY [ ( seed , increment ) ]
   }

Seems simple enough but when I try to execute this:

ALTER TABLE TruckRun
    ALTER COLUMN WinUserName DROP DEFAULT

in Management Studio I get this:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'DEFAULT'.

I must be missing something elementary but that looks like it should work to me.