By Peter Morris
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)
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)
