Altering the length of an existing column

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)

 

Share this article!

Follow us!

Find more helpful articles: