How to modify column length?

Because of business reasons, we need to increase the table column from string (100) to string (200), I did not find how to modify it in online documents, how can I do it?
Thanks a lot!

1 Like

This is a new feature in CockroachDB 2.1. Try:

ALTER TABLE yourtable ALTER COLUMN yourcolumn TYPE STRING(200);

Does this work?

Thanks for your answer!
My db current version is v1.1.4,i’ll try it after upgrade.