Adding a Column
ALTER TABLE student ADD email VARCHAR(30);
Rename Column
ALTER TABLE student RENAME COLUMN CGPA TO GPA;
Dropping Columns
ALTER TABLE student DROP COLUMN email;
Modifying Data Type
ALTER TABLE student MODIFY sname VARCHAR(40);
Clear all Entries of Table
TRUNCATE TABLE faculty;
Deleting a Table
DROP TABLE student;