Reset Ident Column in Database

This is a very handy little script to generate a script to reset the ident column of all your database tables. This can be handy after filling and truncating tables. This script uses a schema “ps”. Replace it with .dbo if needed.

SELECT '
GO
DBCC CHECKIDENT(''ps.' + TabelNaam  + ''',RESEED,0)'
 
FROM
-- LT: Linked Tables
(SELECT O.name AS TabelNaam
, S.name AS SchemaName
FROM sysobjects AS O
LEFT OUTER JOIN sys.schemas AS S ON O.uid = S.schema_id
WHERE O.type = 'u' AND O.uid=5
AND CHARINDEX('_',O.name)=0
--ORDER BY O.[name]
) AS LT
WHERE SchemaName = 'ps'
ORDER BY TabelNaam

Usefull to export the output to text in stead of grid.

After running the script, copy the result to a new window and run it!