ALTER COLUMN error is keeping me from finishing this program

[majorbroncosfan]

When I try to alter a column for one of my tables, I get the following error:

"ALTER TABLE ALTER COLUMN HoursMTD failed because one or more objects access this column. The object 'DF_tblPerson_Hours_3FA063D3' is dependent on column 'HoursMTD'"

I am trying to alter the HoursMTD column from a numeric data type to a varchar in order to use signed equivalents for importing into a COBOL database.

 

[RickCole]

You will first need to drop the default constraint
'DF_tblPerson_Hours_3FA063D3' which is set to this column before you can alter the column.

Rick.