TRUNCATE

WARNING THIS IS EXTREMELY DANGEROUS NEVER USE IT!!!

TRUNCATE TABLE SchemaName.TableName

Sort of a super delete, and fully resets a table…

This will remove all rows from a table.

But it will also reset the ID counter, so all new entries have an ID starting from 1.

Where as with delete they will continue after the greatest row ID that has existed.