ALTER TABLE and DROP Commands

ALTER — Change Structure

ALTER TABLE students ADD email VARCHAR(60);     -- add column
ALTER TABLE students MODIFY name VARCHAR(80);   -- change type
ALTER TABLE students DROP COLUMN email;         -- remove column
ALTER TABLE students RENAME TO learners;        -- rename table

DROP — Delete Object

DROP TABLE students;       -- deletes the whole table
DROP DATABASE school;      -- deletes the whole database

Summary

• ALTER changes a table's structure (add/modify/drop column, rename).
• DROP deletes an entire table or database permanently.

ALTER — Structure बदलें

ALTER TABLE students ADD email VARCHAR(60);     -- column जोड़ें
ALTER TABLE students MODIFY name VARCHAR(80);   -- type बदलें
ALTER TABLE students DROP COLUMN email;         -- column हटाएं
ALTER TABLE students RENAME TO learners;        -- table rename

DROP — Object हटाएं

DROP TABLE students;       -- पूरी table delete
DROP DATABASE school;      -- पूरा database delete

सारांश

• ALTER table का structure बदलता है (add/modify/drop column, rename)।
• DROP पूरी table या database स्थायी रूप से delete करता है।