Insert data into a column where other columns have constraints
You cannot insert a row without specifying values for columns that have NOT NULL constraints. What would be the point of having NOT NULL constraints on those columns if it wasn't enforced?

You would need to remove the NOT NULL constraint clause for each column in the table in order to insert a row that only contains the Zip code value.

This begs the question:  Are you really trying to insert a row that ONLY has a zip code, and nothing else?  Or are you actually trying to modify the zip code for already existing rows in the table?  If that is the case, you need to use an UPDATE &lt;TABLE&gt; statement, not an INSERT INTO statement.