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