empty tsql table code example Example 1: query to empty table data in sql server TRUNCATE TABLE table_name; Example 2: empty an sql table TRUNCATE TABLE table_name;