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

Forum Navigation
VisualNEO Products: Web, Win and PixelNEO
You need to log in to create posts and topics.

modify the character length of a text field in a table

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

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.

Open chat
1
Do you need more info?
Hi, do you have any doubt?