Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
How to delete/remove column from table in SQL
3510 Views
Hints 
drop column query used to delete the existing column in table.In the following example,How to dop the table from database shown.
Syntax
alter table tableName
drop column columnName;
Example
Delete the formerly created column shipregion.

alter table Orders
drop column shipregion;
  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