empty a column

[error_22]

How do you empty a column (all rows) on information?

I know its possible to "TRUNCATE" a table, is it possible to do the same with just a column?

Thanks in advance
Niklas

[devinemke]

UPDATE table SET column = NULL

note that results will depend on your RDBMS/column type/attributes. for example in mySQL if the column allows NULL then every row will be NULL. if the column does not allow NULL then the result would be en empty string for string types. if the column is a DATETIME type and does not allow NULL then each row will be 0000-00-00 00:00:00.