Increase the size of datatype of existing table
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
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ankit NandekarPosted Apr 21, 2011, 3:59 AM
go to table designand Change it or writeALTER TABLEquery.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