How to clear tables using TRUNCATE in Microsoft SQL Server

Let's assume you've a table that you want to delete and making another one similar exactly, it's not necessary to make new table. What you will do is simple just do the following instructions :- - just do left click on the specific database that has the table you want to clear - left click on New Query button then type the SQL command Truncate Table TableName - left click on Execute button And you can rename the table when you do right click on the table and left click on rename. I hope you enjoyed watching the video :)