V4RB2 Alter Table Question

[Ruslan Zasukhin]

On 8/31/06 4:54 PM, "Ivan Smahin" <ivan_smahin at valentina-db.com> wrote:

>> Screenshot from viSQL and database for testing
> 
> Yes, I see.

> The source of "problem" is filled table.

> You  can  not add not-nullable field or field without default value to
> filled table.

> Simple  reason  -  what  values do you expect to see in that field for
> existing records?

Aha. 

Ivan, other dbs like MSSQL, Sybase do the same thing ?

May be it needs improve error message ?
E.g.
    

    you cannot add new NOT NULL column without DEFAULT value
    into that table have records
    
?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]