Write SQL query to delete the one column of table?

Answer 1

Ore Adeleye I get know the answer.. in this query. Keyword is missing..

So this ans will be -

ALTER TABLE table_name
DROP COLUMN column_name

Answer 2

ALTER TABLE table_name;
DROP COLUMN column_name;

Answer 3

Nikhil Kulkarni It seems your question appears to be an assignment. Please show us your attempt and use the 8 rules to get help from the community.
https://www.sololearn.com/Blog/38/8-simple-rules-to-get-help-from-the-community

*can be a code coach solution which is meant for you to do to help you establish your skills abilities and where you need to learn... not the community
*one issued by a school or other institution
*one issued or created by another platform
*one that appears to be in the form of a challenge that was created by you or somewhere else.

Your question will be reviewed by a team of moderators and will most likely be marked for deletion.
https://www.sololearn.com/Discuss/1316935/?ref=app

Answer 4

ALTER TABLE table_name
DROP column_name

Answer 5

Nikhil Kulkarni You are right. My bad

Answer 6

Read solo lesson of sql hope u will find answer