truncate table syntax code example
Example 1: query to empty table data in sql server
TRUNCATE TABLE table_name;
Example 2: sql truncate table
-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;
Example 3: truncate table
TRUNCATE TABLE table;