title: Why does SQL Server force me to drop the table to be able to alter a field from DateTime to DateTime2(3)?
body: <p>I am trying to alter a table field - with some rows in it - from <code>DateTime</code> to <code>DateTime2(3)</code>.</p>
  
  <p>But the SQL Server Management Studio complains that I have drop and re-create the table.</p>
  
  <p>But why?</p>
  
  <p>Isn't <code>DateTime2(3)</code> has more precision than <code>DateTime</code> type? It should be fine, should not it be?</p>