BUG: DCR: SQL Server Books Online Incorrectly States That IS_NULLABLE Returns YES or NO (272496)

The information in this article applies to:

This article was previously published under Q272496

BUG #: 58190 (sqlbug_70) BUG #: 235052 (shiloh_bugs)

SYMPTOMS

SQL Server Books Online states that IS_NULLABLE returns YES or NO when it actually returns YES or No.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

The following query demonstrates this problem:

use pubs
go
select IS_NULLABLE
from information_schema.columns
where table_name='authors'
go

returns:

IS_NULLABLE 
----------- 
No 
No 
No 
No 
YES
YES
YES
YES
No 

(9 row(s) affected)

Modification Type:	Major	Last Reviewed:	10/16/2003
Keywords:	kbBug kbpending KB272496