what does truncate table do code example Example 1: query to empty table data in sql server Click to copyTRUNCATE TABLE table_name; Example 2: truncate table Click to copyTRUNCATE TABLE table;