Knowledge Hub — Technical Document

Generated on 2026-10-13 05:52 | Confidential Client Asset

Altering and Truncating Tables in MySQL

Published October 04, 2026 By Sai Sree Ram Gundepudi

ALTER TABLE

ALTER TABLE employees ADD email VARCHAR(100);

RENAME TABLE

RENAME TABLE employees TO staff;

TRUNCATE TABLE

TRUNCATE TABLE staff; -- Deletes all rows without logging

Use with caution, TRUNCATE is irreversible!

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

ALTER, RENAME, TRUNCATE

Modifying Tables with ALTER, RENAME, and TRUNCATE

ALTERALTER TABLE students ADD email VARCHAR(255);RENAMERENAME TABLE students TO alumni;TRUNCATETRUNCATE TABLE alumni;Not...