Clear all data from all tables and reset id ms sql server

Use truncate for this, as delete query will not reset the identity column value. Truncate table table_name.

You can use the sp_MSforeachtable stored procedure like so: USE MyDatabase EXEC sp_MSforeachtable 'TRUNCATE TABLE ?' Be warned that this will delete (by truncation) ALL data from all user tables. And in case you can't TRUNCATE due to foreign keys etc. you can run the same as a delete: USE MyDatabase EXEC sp_MSforeachtable 'DELETE FROM ?'