title: Safely change column data type in SQL Azure
body: <p>SQL Azure has a dependency of each table being required to have a clustered index. I have two tables that have a FK dependency on each other, with one of the tables using the.  That data type needs to be changed from a VARCHAR to an INT.  This requires that the index and FK relationship be dropped temporarily to fix any potentially dangerous data, and then to alter the column to be the same data type, then restore the FK and index.  </p>
  
  <p>How can this be done without throwing errors in SQL Azure?</p>