Delete a column from a table

Replies

• 

  Kaustubh Katdare

  Naresh Arsh

  I have small query please give me solution for this.
  my query is i want to delete a column from a table .

  Right click on the column and select 'Delete'. It's very easy.
• 

  Prasad Ajinkya

  Know your DDL!
  
  Also Google!
  
  Alter table name drop column name;
• 

  Neeraj Sharma

  Naresh Arsh

  I have small query please give me solution for this.
  my query is i want to delete a column from a table .

  ## Dropping one column
  ALTER TABLE table_name DROP COLUMN column_name;
  
  ##Dropping multiple columns
  ALTER TABLE table_name DROP COLUMN (column_name1, column_name2,...);
• 

  Kaustubh Katdare

  Too many assumptions here, right? 😁
• 

  Neeraj Sharma

  Kaustubh Katdare

  Too many assumptions here, right? 😁

  I didn't get you.. 😨
• 

  Kaustubh Katdare

  Neeraj Sharma

  I didn't get you.. 😨

  The original question does not talk about deleting a column from mysql database or excel or an HTML table. 😀 I just wish people could ask questions without making assumptions.
• 

  Vishal Sharma

  Kaustubh Katdare

  The original question does not talk about deleting a column from mysql database or excel or an HTML table. 😀 I just wish people could ask questions without making assumptions.

  We should probably wait for the #-Link-Snipped-# to return and clarify that. But i'm sure its not an excel table column or word table column 😁 And the right click, delete doesn't workout on HTML 😛
• 

  Rahulkumar200

  Try this
  ALTER TABLE table_name
  DROP COLUMN column_name;
• 

  Rahulkumar200

  And if you wanna !"add some columns"! try this
  ALTER TABLE table_name
  ADD column_name column-definition;
• 

  Vishal Sharma

  Rahulkumar200

  Try this
  ALTER TABLE table_name
  DROP COLUMN column_name;

  already answered by #-Link-Snipped-#