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