Remove the constraint on object before deleting your field
The constraint is typically created automatically by the DBMS (SQL Server).
To see the constraint associated with the table
in SSMS -> expand the table attributes in Object explorer -> category Constraints -> right click on constraint and click delete