modify the character length of a text field in a table

#1 · November 17, 2020, 9:36 pm

I have a database in use that has a table and within this table I have a text input record that is Name and has a maximum length of 40 characters, how can I edit and change this value to 100 since I could do it from scratch but I would lose the data that are already stored ... any ideas ??? thank you

#2 · November 18, 2020, 2:25 pm

It depends on the database you are using, but you should be able to do it with a simple SQL command similar to this one:

ALTER TABLE tableName ALTER COLUMN Name VARCHAR (100)

Regards.

modify the character length of a text field in a table - Forum

modify the character length of a text field in a table