null value for all rows of a column!

Question

Hi Is there any way for setting all the rows of a column to a null value? thanks

Answer 1

How about something simple like : Update MyTable Set MyColumn = NULL

Or, did you mean you wanted to set all columns in a row to NULL? If so, you have a database design problem. You should greatly limit what columns in a database accept NULL values.

Answer 2

Sure.

UPDATE table SET column = NULL

If you don't include a WHERE clause, the statement will affect all the rows in the table.