Find the statictics on an Object and Drop them

Hi,

With the below query we can get the statictics detail of an object and drop them

SELECT name, OBJECT_NAME(OBJECT_ID) AS ObjectName
FROM sys.stats
WHERE auto_created = 1
and OBJECT_NAME(OBJECT_ID) = '<OBJECT_NAME>';

DROP STATISTICS <OBJECT_NAME>.PrimaryKey