Any easy way to change column length like varchar 30 to varchar 100?

#1 (**permalink**) 02-29-2008, 06:52 AM

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.

#2 (**permalink**) 02-29-2008, 06:52 AM

On 31 Jan 2005 07:05:21 -0800, sdowney717@msn.com wrote:

>
>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.

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
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

#3 (**permalink**) 02-29-2008, 06:53 AM

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

#4 (**permalink**) 02-29-2008, 06:53 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode