-- truncate is faster - like select all delete all but in DELETE it's like backspace where one by one data is deleted alter table emp_info drop column location; -- since column has to be deleted ...