Modify Columns (Database Engine)

You can modify the data type of a column in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL. ... Caution Modifying the data type of a column that already contains data can result in the permanent loss of data when the existing data i

technet.microsoft.com