Delete a column from a table

Naresh Arsh

@naresh-arsh-xo9Gos • Oct 26, 2024

Oct 26, 2024

1.4K

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

Like 0 Replies 10

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Kaustubh Katdare

@thebigk • Apr 11, 2015

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.
0
Prasad Ajinkya

@prasad-aSUfhP • Apr 14, 2015

Know your DDL!

Also Google!

Alter table name drop column name;
0
Neeraj Sharma

@neeraj-iAaNcG • Apr 18, 2015

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,...);
0
Kaustubh Katdare

@thebigk • Apr 18, 2015

Too many assumptions here, right? 😁
0
Neeraj Sharma

@neeraj-iAaNcG • Apr 18, 2015

Kaustubh Katdare
Too many assumptions here, right? 😁
I didn't get you.. 😨
0
Kaustubh Katdare

@thebigk • Apr 18, 2015

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.
0
Vishal Sharma

@vishal-pysGmK • Apr 18, 2015

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 😛

0
Rahulkumar200

@rahulkumar200-AzMcLQ • Apr 27, 2015

Try this
ALTER TABLE table_name
DROP COLUMN column_name;
0
Rahulkumar200

@rahulkumar200-AzMcLQ • Apr 27, 2015

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

@vishal-pysGmK • Apr 27, 2015

Rahulkumar200
Try this
ALTER TABLE table_name
DROP COLUMN column_name;
already answered by #-Link-Snipped-#

0