+ 1

Write SQL query to delete the one column of table?

18th May 2020, 6:23 AM
Nikhil Kulkarni
Nikhil Kulkarni - avatar
6 Antworten
+ 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
18th May 2020, 7:26 AM
Nikhil Kulkarni
Nikhil Kulkarni - avatar
+ 1
ALTER TABLE table_name; DROP COLUMN column_name;
20th May 2020, 10:31 AM
Bikash Jena
+ 1
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
7th Feb 2021, 2:46 AM
BroFar
BroFar - avatar
0
ALTER TABLE table_name DROP column_name
18th May 2020, 6:45 AM
Ore
Ore - avatar
0
Nikhil Kulkarni You are right. My bad
18th May 2020, 8:22 AM
Ore
Ore - avatar
0
Read solo lesson of sql hope u will find answer
19th May 2020, 4:43 AM
A S Raghuvanshi
A S Raghuvanshi - avatar