title: Unable to Modify User-Defined Table Type
body: <p>I have a SQL <code>User-Defined Table Type</code>. It used in many
  stored procedures.Now i need to change a column in that table type.
  I tried to drop and recreate the <code>User-Defined Table Type</code>.But SQL Server 
  doesn't Allow that. It shows up following error.</p>
  
  <pre><code>Msg 3732, Level 16, State 1, Line 3
  Cannot drop type 'dbo.UserDefinedTableType' because it is being referenced by object 'SP_DoSomething'. There may be other objects that reference this type.
  Msg 219, Level 16, State 1, Line 3
  The type 'dbo.UserDefinedTableType' already exists, or you do not have permission to create it.
  </code></pre>
  
  <p>How to alter the <code>User-Defined Table Type</code> without modifying all the Stored procedure that uses <code>User-Defined Table Type</code> ?</p>