Delete all Data in a column in a table

  • Thread starter Thread starter Sierras
  • Start date Start date
S

Sierras

Is there an easy way to delete all the data in a specific column on a
single table? I want the rest on the data in that table to stay the
same.
 
Is there an easy way to delete all the data in a specific column on a
single table? I want the rest on the data in that table to stay the
same.
Click to expand...

Run an update query:

UPDATE YourTable SET YourTable.FieldName = Null;
 
Back
Top