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%’