DDL: Truncate

TRUNCATE will do two things for you: 1) Drop your table 2) Recreate your table

This is handy, but be aware that because this is a DDL, it can’t be rolled back like DELETE, which is DML.

TRUNCATE TABLE dbo.Songs;