Thanks for this easy question ( not surprising as it is the week-end ).
Just a little remark : this question was treated 3 years ago in a session by an escalation engineer who did a remark maybe important : it is possible to decrease the size of a column ( varchar/nvarchar ) if for all the rows , the new size is bigger than the maximum size of the column in all rows.
As I am not sure to be clear ( I am admitting that I have a poor written English language and the spoken one is worst ) : I have 4 rows with the values
value1 value01 value001 for a varchar(20) no problem to decrease the size to varchar(10) , but it is impossible to change to a varchar(7) as the size of value001 is 8.
If I am going wrong , please , could you provide a link giving a full ( and easy ) explanation for my error ? Thanks beforehand.
Have a nice day/week-end.