Q:

Alter column should not allow nulls

i cannot find any way to execute this - all i need is to add column but not allow nulls to
existing table.
ALTER TABLE IP_USER ADD troller bit DEFAULT 0

when i use this syntax all the rows get Null.
what is the syntax i'm looking for?

A:

You should always specifiy NULL or NOT NULL constraint
ALTER TABLE IP_USER ADD troller bit NOT NULL DEFAULT 0

