DELETE statement is used to delete rows from a table.
DELETE FROM Candidates WHERE CandidateId > 1000;
TRUNCATE TABLE Candidates;
DROP TABLE Candidates;