TRUNCATE TABLE IN SQL SERVER MANAGEMENT STUDIO 18
A truncate SQL statement is used to remove all rows (complete data) from a table. It is similar to the DELETE statement with no WHERE clause.
Truncate table is faster and uses lesser resources than DELETE TABLE command.
Drop table command can also be used to delete complete table but it deletes table structure too. TRUNCATE TABLE doesn't delete the structure of the table.
TRUNCATE TABLE table_name;
TRUNCATE TABLE IN SQL SERVER MANAGEMENT STUDIO 18