t sql delte code example Example 1: query to empty table data in sql server TRUNCATE TABLE table_name; Example 2: delete all records from table DELETE FROM table_name;