Interview Question

What is ALTER TABLE?

ALTER TABLE changes an existing table definition.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

ALTER TABLE changes the definition of an existing table. • It can add, remove, rename, or change columns and constraints. • Some alterations require existing data to satisfy the new rule. • Locking and rewrite behavior depends on the database and operation.

💡 SQL Example

ALTER TABLE employees ADD COLUMN hired_on date;

Result

ALTER TABLE

⚡ Quick Revision

ALTER TABLE changes an existing table definition.

←

PreviousWhat is CREATE TABLE?

NextWhat is DROP TABLE?

→