delete all rows query mssql code example Example: query to empty table data in sql server TRUNCATE TABLE table_name;