Increase the size of datatype of existing table

Question

I want to increase the data type of varchar(100) to varchar(200)?without any loss of data in the existing table?HOW ?I am using MSSQL

Ankit Nandekar · Answer

Just go to table design and Change it or write ALTER TABLE query. If you increase the size it will not affect any data. But if you decrease the size there is a chance of losing the data. bcoz u r increasing a size than no problem just use alter table query. like ALTER TABLE [tablename] ALTER COLUMN [column name] VARCHAR(100) If this information is useful for u than mark as accepted answer.