-- Add a single column ALTER TABLE employees ADD phone VARCHAR(20); -- Add a column with a default for existing rows ALTER TABLE employees ADD department VARCHAR(50) DEFAULT 'Unassigned';
Click Run to execute this code.