Clear all data in DB table

USE database

 

--

DECLARE @SQL VARCHAR(8000)

SET @SQL = ''

SELECT @SQL = @SQL + 'DELETE FROM [' + [Name] + '];' + CHAR(10) FROM SYS.OBJECTS WHERE TYPE='u'

--

SET @SQL = @SQL + @SQL + @SQL

PRINT @SQL

BEGIN TRY

      EXEC(@SQL)

END TRY

BEGIN CATCH

END CATCH