>>Hi everybody,
>>
>>I'm writing a create table script.
>>
>>I see there something like
>>[Approved] [bit]
>>NOT NULL CONSTRAINT [DF__Registrat__Appro__19169DBB] DEFAULT ((0)),
>>
>>I want to add another field with the default value. Is it possible to give some useful name for these constraints?
>>
>>Thanks a lot in advance.
>>
>>UPDATE. Yes, I guess I can.
>
>Naomi,
>Yes you can do that in code easily. However there is another option. If you create Diagram, you can create constraints, indexes ... there and say SQL server to generate the scri[pt as well.
>Cetin
Thanks, Cetin.
If it's not broken, fix it until it is.
My Blog