Null for all rows in a column!

Question

Is there a way to set all column rows to null? thank

Answer 1

How about something simple: Update MyTable Set MyColumn = NULL

Or, did you mean that you want to set all the columns in a NULL row? If so, you are having a database design issue. You should significantly limit which columns in the database are NULL.

Answer 2

Of course.

UPDATE table SET column = NULL

If you do not include a clause WHERE, the statement will affect all rows in the table.