Changing the column to the selected data type will delete its indexes. (Visual Database Tools)
SQL Server 2005
The column whose data type you are changing contributes to one or more indexes. The modification will delete the indexes. Choose Yes to proceed with the modification and delete the indexes. Choose No to cancel the modification.