On 8/31/06 6:41 PM, "Claudius Sailer" <Claudius (AT) sailer-online .D.OT de> wrote:
> I would expect something like this
>
> ALTER TABLE Kategorien ADD Beinflussbarkeit=3 Byte NOT NULL
>
> or
>
> ALTER TABLE Kategorien ADD Beinflussbarkeit Byte NOT NULL SET
> Beeinflussbarkeit=3
>
> but in the table description there is nothing with DEFAULT=3. Now I
> have in table description for this field the information DEFAULT=3
> something I don't want.
Claudius,
MS SQL show this error in this case:
-----------
Adding column must be nullable or have a DEFAULT definition specified for
not empty table. The column "" cannot be added to table "" because it does
not allow null values and does not specify a DEFAULT definition.
-----------
So we think that we do correct steps now.
--
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]
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Ruslan Zasukhin |
