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@metux.de
 cellphone: +49 174 7066481         smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/