If you've created a table that contains columns with a NOT NULL constraint and then later find that you want to allow NULL values in that column then here is the SQL to alter your column constraint:
ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;
Conversely, to add a NOT NULL constraint to an existing column use:
ALTER TABLE mytable ALTER COLUMN mycolumn SET NOT NULL;