Alter Table Add field

[Ruslan Zasukhin]

on 12/9/03 1:14 PM, Tim James at tjames1 at bigpond.net.au wrote:

> I know this has been mentioned some time ago, but has there been any
> change to
> 
> so that alter table add field adds the field
> at the END of the schema description so that any
> original select * statements don't have to be respecified

Hi Tim,

It adds column to the end.
And I think this will be always.

This is VERY NOT correct expect some order of fields in the SELECT * !!!

This is written in all books and is true for each DBMS.

Never expect this.

IF you need some order, you MUST specify

        SEELCT f1, f2, ...


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------