>>>>I've looked at Help on ALTER TABLE and I don't see if it requires exclusive access or not.
>>>
>>>Yes it is
>>>
>>
>>Is there any other way to change the structure of the existing table?
>
>Nope, you are changing the table structure :-) not a value of the field.
Yes, thanks - for a minute I thought there may be way around it. BTW, how can we set (check) for the default value of the field?
If it's not broken, fix it until it is.
My Blog