Drop the column of table in MSQL by R4R Team

We can Drop/delete/Remove the specify column from the column using the ALTER command by the following command:

Syntax:
ALTER TABLE table_name
DROP COLUMN column_name;

SHOW library;

Id Stud_name Book_Id Issue_date
1 Aman 234 19-12-2019
2 Ram 213 12-12-2019
3 Ramesh 89 19-10-2019
4 John 567 18-11-2019


Now we delete the column Issue_date by the following command:

ALTER TABLE library DROP COLUMN Issue_date;


Id Stud_name Book_Id
1 Aman 234
2 Ram 213
3 Ramesh 89
4 John 567


Leave a Comment:
Search
Categories
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!