In MySQL to empty the contents of a table and reset the increment count I would use the following SQL command:

Truncate TableName

What is the syntax in MS-SQL?

TIA,

truncate table [tablename]