About Truncate

Truncate is SQL database programming language command which is used for deleting whole the records of database means we can delete the all rows and columns from table without Table delete. Truncate table removes all rows from a table but the table structure and its columns, constraints, indexes, and so on remain. If we wants remove the table definition in addition to its data then we use the DROP TABLE statement or command. If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. Truncate table cannot activate a trigger because the operation does not log individual row deletions.