PDA

View Full Version : Changing type in a Sql Table


Daemon
10-01-2005, 03:08 AM
I need to change the sql table Links_PLD (description) to long text.

If I just drop it and re-create it, will I lose all the data that is in it? If I would change it, is it possible to recover the data and replace into the correct Description field?

YkTan has addressed this as part of what we have been doing, but I am unclear about the loss of data issue, since I can re-create no problem but I dont want to lose the 600+ links already in the database.

Thanks for any assistance..

Daemon