Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'Allow nulls' on BIT fields
Message
From
21/02/2001 08:25:17
 
 
To
20/02/2001 23:37:44
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00477894
Message ID:
00477904
Views:
26
>I am runing SQL Server 7.0 on Win2000 professional. In the the SQL Server Enterprise manager when designing a table the "Allow Nulls" column cannot be checked for BIT field types. This prevents me from adding a BIT field to an existing table as the table cannot be saved because it contains nulls in the new BIT field.
>
>Does anyone now how to overcome this situation?

I'm not sure, but I think if you put in a default value you will be able to add your field. Of course, all your records will have that default value.
Sylvain Demers
Previous
Reply
Map
View

Click here to load this message in the networking platform