Alter columns Without Dropping Table

Have you ever suffered with this error massage? When you try to Update Table column Data types. Did you delete the Table and re-create it? 

There are two a Solutions Which SSMS Provided,

Please follow These Simple Steps

Option 1:

Go to Tools->Options

 

Click Designers tab->Table Options

Un tick Prevent saving changes that require table re-creation

 

Option 2:

Using ‘Alter table’ SQL command you can update the column

 ALTER TABLE <TABLE_NAME>

ALTER COLUMN <COLUMN_NAME> <DATA TYPE>

PS: - You can Use Method 1 for the Data warehouse changes which client raised without losing loaded Data or reloading tables

   Thank You !..