Delete column value through delete statement
How can I delete a specified column value through delete statement.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Santhosh Kumar JayaramanPosted Aug 16, 2012, 8:28 AM
Just think if you delete a column value, how the table looks like? thats why its not allowed
Sharad GuptaPosted Aug 16, 2012, 8:27 AM
Santhosh Kumar JayaramanPosted Aug 16, 2012, 7:53 AM
You want to delete only one column in your table?
The only way is just Update the column to null
update tbl
set col1=null