sql server (alternate):
I would like to increase the length of the column from
LOCNumber VARCHAR(30) DEFAULT ''

to
LOCNumber VARCHAR(100) DEFAULT ''

without losing any data currently stored in the field.


And it has an index on it defined as
CREATE INDEX LOCIndex ON BookData(LOCNumber)

Thanks for any help.

That works well, thanks very much
Do you know how to do this with MySQL as well?

Found it, you use this
ALTER TABLE BookData MODIFY COLUMN LOCNumber varchar(100)

[quoted text, click to view]

Hi sdowney,

Just use ALTER TABLE:

ALTER TABLE BookData
ALTER COLUMN LOCIndex varchar(100)

No need to re-specify the default - it won't be changed.

Best, Hugo
--