## BUG: Schema Generate Does Not Include NOT NULL on Some Columns

Q113157

The information in this article applies to:

- Microsoft SQL Server version 4.2x

BUG# 9893 (4.2)

## SYMPTOMS

Object Manager's schema generate function does not put NOT NULL on columns defined with a user datatype which allows nulls, even if NOT NULL was included in the original table definition.
If the table specifies NOT NULL on a column which uses a user-defined datatype which allows nulls, schema generate will not include the NOT NULL in its generated scripts. For example, if a site does:

       use pubs
       go
       sp_addtype nulltyp, 'char(10)', NULL
       go
       create table nulltab
         (cola int, colb nulltyp NOT NULL)
       go

Then if the site uses schema generator to generate a script with all objects, users and logins, the NOT NULL clause will not be included in the generated script.

## STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Windows NT

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2

Last Reviewed: April 4, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use.