Imagine the name of the table is "CUSTOMER", and the column name is "NAME" - which is a varchar. Here is how to change the length of the column without losing data.
ALTER TABLE CUSTOMER ALTER COLUMN NAME TYPE VARCHAR (64)
How To Do Things. Copyright Howtodothings.com © 2016, all rights reserved.