Showing posts with label completlydelete. Show all posts
Showing posts with label completlydelete. Show all posts

Sunday, March 25, 2012

Delete all data from single column question

Does anyone know the correct syntax for using the DELETE command to completly
delete/remove all data from a single column within a given table only? I do
not want to save the data from column A. I would like to have the column
left in place with no data. Thanks for any info.
"brettr78" <brettr78@.discussions.microsoft.com> wrote in message
news:DDF0D6CB-CABF-49E8-A48A-DF6D0C4C62FE@.microsoft.com...
> Does anyone know the correct syntax for using the DELETE command to
completly
> delete/remove all data from a single column within a given table only? I
do
> not want to save the data from column A. I would like to have the column
> left in place with no data. Thanks for any info.
Depending on the datatype, something like:
UPDATE Foo
SET column_x = NULL
Rick

Delete all data from single column question

Does anyone know the correct syntax for using the DELETE command to completl
y
delete/remove all data from a single column within a given table only? I do
not want to save the data from column A. I would like to have the column
left in place with no data. Thanks for any info."brettr78" <brettr78@.discussions.microsoft.com> wrote in message
news:DDF0D6CB-CABF-49E8-A48A-DF6D0C4C62FE@.microsoft.com...
> Does anyone know the correct syntax for using the DELETE command to
completly
> delete/remove all data from a single column within a given table only? I
do
> not want to save the data from column A. I would like to have the column
> left in place with no data. Thanks for any info.
Depending on the datatype, something like:
UPDATE Foo
SET column_x = NULL
Rick