Modifying Tables with ALTER, RENAME, and TRUNCATE

ALTER

ALTER TABLE students ADD email VARCHAR(255);

RENAME

RENAME TABLE students TO alumni;

TRUNCATE

TRUNCATE TABLE alumni;

Note: TRUNCATE deletes all rows but keeps structure.