Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
How to remove/delete the column(truncate) values from Table in SQL
2651 Views
Hints 
Truncate query used to remove the values of column in table(i.e not Delete the table from the database).If you use drop query, remove the values and also remove the column name completely(i.e  Delete the table from the database).

In the following example, I used truncate query for table to remove all the values.
Syntax
truncate table tableName;
Example
truncate table orders;
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details