TRUNCATE TABLE employee; --its delete all the data of table but can't reset series if any TRUNCATE TABLE employee RESTART IDENTITY; --for restart the series of employee id after delete data ...