By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,412 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,412 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.