>Nadya,
>
>IU would suggest that you break your command down and add one piece at a time until it breaks. When it breaks it is the last piece you added that broke it. I got this line of code to work fine on a table named junk with one fiedl named char1.
>
>

>ALTER TABLE junk ALTER COLUMN char1 C(12) NULL
>

Hi Jim,

I just found this:

alter table bldstack alter column term drop check alter column term N(4,0)

&&Works fine - Drop check preceeds changing size

alter table bldstack  alter column term N(4,0) alter column term drop check

&&Gives an error - no rule to drop. (Rule exists, I added it each time again for my tests).

IOW, if Drop check preceeds other changes of this field (size or type) - it works.
If I change the order and try to change size, then drop check in the same command - it fails.

I don't have an explanation of this weird behavior, but I guess, I should re-program my program to drop rule first.