delet table from db sql code example Example 1: query to empty table data in sql server TRUNCATE TABLE table_name; Example 2: drop a table DROP TABLE table_name;