I have created an application and I have used this piece of code (which I have found on the Internet) to clear all the data and reset the Identity of the Identity columns of the tables.

```
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' 
GO 

EXEC sp_MSForEachTable 'DELETE FROM ?' 
GO 

EXEC sp_MSForEachTable 'DBCC CHECKIDENT(''?'', RESEED, 0)'
GO

EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL' 
GO

```

But I have two tables which do not have `Identity` columns and that gives me a problem saying:

> 
> Msg 7997, Level 16, State 1, Line 616  
> 
>  'SupplierBalance' does not contain an identity column.
> 
> 
> Msg 7997, Level 16, State 1, Line 616  
> 
>  'CustomerBalance' does not contain an identity column.
> 
> 
> 

I want to know if there is a way to reset the identity of the columns of the tables, which only have identity columns without getting an error.

Thank you.