BUG: Table Designer Cannot Create a Bit Column Which Allows NULL

• Microsoft SQL Server version 7.0

SYMPTOMS

When using the SQL Server Enterprise Manager Table Designer to create a table, you cannot create a bit column that allows NULLs. The Allow Nulls check box will not accept a check mark.

WORKAROUND

To work around this problem, use Query Analyzer to issue the Transact-SQL CREATE TABLE statement. The CREATE TABLE statement allows you to create a nullable bit column. For example, use the following statement:

CREATE TABLE mytable ( f1 bit NULL ) 

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: prodsql

Keywords          : kbbug7.00 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: June 17, 1999