SQL Anywhere Feedback - alter table add default not null

Author

alter table add default not null

krisztian pinter

2005-11-25, 7:23 am

on a non-empty table, adding a not null field with default fails,
because non-empty tables can not be extended with a not null field.

however, adding a nullable field with default is OK, and it fills
the new column with the default value nicely!

so, why ASA lament in the first example?? please, please, please,
don't complain, but do your job!

ps: i have ASA 8 only. if it is addressed already, ignore this post

Dmitri

2005-11-25, 7:23 am

krisztian pinter wrote:

> on a non-empty table, adding a not null field with default fails,
> because non-empty tables can not be extended with a not null field.

----------------------------------------------------
What's New in SQL Anywhere Studio
What's New in Version 9.0.1
New features in version 9.0.1

Adaptive Server Anywhere new features

....

ALTER TABLE statement enhancement ALTER TABLE can now add a NOT NULL
column with a default value to a non-empty table. This feature provides
increased flexibility when modifying existing tables.

....
----------------------------------------------------

Dmitri.

Sponsored Links