ALTER TABLE Students DROP COLUMN Email;
DROP COLUMN statement will completely remove a column from a table along with rows that exist in that column. For example, if there is a table named 'Employee' which has a column FirstName. If you want to remove this column from the table you can run the below query.
ALTER TABLE Employee DROP COLUMN FirstName;