January 24, 2002 02:24 PM

Changing a Column from NOT NULL to NULL in T-SQL

Rating: (0)
SQL Server Magazine
InstantDoc ID #23501

I'm using Enterprise Manager to alter the structure of a table that has 3 million rows. Enterprise Manager locks up whenever I try to change the nullability of one column from NOT NULL to NULL. Is this problem a known bug?

The problem might be recognized as a bug if Enterprise Manager were actually locking up. However, I suspect a different problem is causing your glitch. In T-SQL, you can use the ALTER keyword to change the nullability of a column. This operation is relatively efficient, even for large tables. However, Enterprise Manager doesn't use ALTER to change nullability.

If ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS