In previous post, we learnt how to add a new column into existing Sql Server database table. In this post, we shall learn how to alter/modify an existing column of a SQL Server database table.
To do that write following query where highlighted words are not keywrods ie we need to change as per our need.
ALTER table MyDetails
Alter column City varchar(100)
Above query translates like