[Zope-DB] How to add a field after another field SQL SERVER
Mon, 15 Apr 2002 10:26:53 -0400
On Sat, Apr 13, 2002 at 02:10:25AM +0200, Mauricio V?lez wrote:
> Hello Everybody
> I'm using sql server and I want to write a script with
> the command ALTER TABLE to add a field.
> By default it is added at the end, but I want to add
> it after another field
> How can I do this?
Completely database dependent. In most, you cannot directly do this.
The canonical way is to dump your data and the definitions, write a
script to reorder them, drop your table from the database and then
reload the modified dump. This is a lot of work and is error prone,
so mostly people just don't do it. After all, by using explicit column
names in your select statements, you can get the order to be whatever
you want, anyway.
> Do You Yahoo!?
> Yahoo! Messenger
> Comunicaci?n instant?nea gratis con tu gente.
> Zope-DB mailing list