SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE tblEmployee ([EmpNo]int, [FullName]varchar(20), [Nickname]varchar(20), [Age]int, [Position]varchar(20), [Salary]float); INSERT INTO tblEmployee ([EmpNo],[FullName],[Nickname],[Age],[Position],[Salary]) VALUES (1001,'Justin Bieber','jb',30,'Supervisor',50000), (1002,'Ariana Grande','riri',25,'Assistant',25000), (1003,'Elon Musk', NULL,45,'CEO',70000), (1004,'Mark Ronaldo','Ron',30,'Manager',30000), (1005,'Leonel Messi','Messi',55,'Manager',30000); ALTER TABLE tblEmployee DROP COLUMN[Nickname]; SELECT * FROM tblEmployee;