how to make a new column to change name format in sql code example

Example: sql alter column size

ALTER TABLE table_name
ALTER COLUMN column_name datatype;