SELECT
'TRUNCATE TABLE ' + quotename(S.name) + '.' + quotename(T.name) + char(13) + char(10) + ' ' + char(13) + char(10)
FROM sys.tables T
JOIN sys.schemas S ON T.schema_id = S.schema_id
AND T.name NOT LIKE '%SomeWordOfTableName%'
** Copy output script to running for delete
SELECT
QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]
, SUM(sPTN.Rows) AS [RowCount]
FROM sys.objects AS sOBJ
INNER JOIN sys.partitions AS sPTN
ON sOBJ.object_id = sPTN.object_id WHERE sOBJ.type = 'U'
AND sOBJ.is_ms_shipped = 0x0
AND index_id < 2 -- 0:Heap, 1:Clustered
GROUP BY sOBJ.schema_id , sOBJ.name
ORDER BY SUM(sPTN.Rows) desc
