Re: full featured alter table?

On Fri, Jun 13, 2003 at 05:05:32PM +0000, Reynard Hilman wrote:

<snip>
> It'd be nice if it allows you to change the type from varchar(40)
> to varchar(20) if you don't have any data that is larger than varchar(20).
Yeah, and then an application comes in and wants to write more than
20 chars ...

well, i dont like such size limitations at all - i'm using "text" instead.
what about efficiency ? does it bring _anything_ to limit the size
of varchar fields ?

> I don't know how much complexity that will add, though. well that's
> just some idea from me.
hmm, i dont think, its really needed. if you really want to do that,
you should also think _very carefully_ 'bout what you're doing.
and so you can type the 3 more statements to create a new table,
copy the data, drop the old table and rename the new one.

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux ITS
Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr.

phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481 smsgate: sms(dot)weigelt(at)metux(dot)de
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/