Knowledge Hub — Technical Document

Generated on 2026-08-28 07:05 | Confidential Client Asset

Modifying Tables with ALTER, RENAME, and TRUNCATE

Published July 26, 2025 By Sai Sree Ram Gundepudi

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.

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

ALTER, RENAME, TRUNCATE

Altering and Truncating Tables in MySQL

ALTER TABLEALTER TABLE employees ADD email VARCHAR(100);RENAME TABLERENAME TABLE employees TO staff;TRUNCATE TABLETRUNCA...