title: Trying to delete a Default, but getting a message that it doesn't exist on the server
body: <p>I need to alter a data type of a column from smallint to bigint (poor design consideration, don't ask). I run the TSQL</p>
  
  <pre class="lang-sql prettyprint-override"><code>alter table dbo.Test alter column ProductionModeID bigint NULL
  </code></pre>
  
  <p>But get the message:</p>
  
  <blockquote>
    <p>Msg 5074, Level 16, State 1, Line 1
    The object 'DF_Test_ProductionModeID' is dependent on column 'ProductionModeID'.</p>
    
    <p>Msg 4922, Level 16, State 9, Line 1
    ALTER TABLE ALTER COLUMN ProductionModeID failed because one or more objects access this column.</p>
  </blockquote>
  
  <p>I have found <code>DF_Test_ProductionModeID</code> in dbo.Test >> Constraints. (I don't know how <code>DF_Test_ProductionModeID</code> was created, nor do I believe I need it to exist). I press Delete, choose OK button, and get the following message:</p>
  
  <blockquote>
    <p>===================================</p>
    
    <p>The Default 'DF_Test_ProductionModeID' does not exist on the server. (SqlManagerUI)</p>
    
    <hr>
    
    <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.ObjectDoesNotExist&amp;LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.ObjectDoesNotExist&amp;LinkId=20476</a></p>
    
    <hr>
    
    <p>Program Location:</p>
    
    <p>at Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DoDropObject(Int32 objectRowIndex)
       at Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DropAllObjects(Boolean stopOnError)</p>
  </blockquote>
  
  <p>So I'm now confused, because if it doesn't exist, then how can it depend on a column?</p>