Drop all user tables statistics

Posted bypandrei


SELECT 'DROP STATISTICS ' + Schema_NAME(d.Schema_id) + '.' +
OBJECT_NAME(a.object_id) + '.' +
a.name colum_name
FROM sys.stats a
INNER JOIN sys.Objects d ON d.Object_id = a.object_id
inner join sys.tables t ON t.object_id = a.object_id
WHERE t.type = 'U' AND auto_created = 1 and a.name LIKE '_WA_Sys%'