Muhammad Abbas - Data Engineering Architect
Pages
CV
Profile
BLOG
Search This Blog
Monday, September 20, 2010
[T-SQL] Find Auto Created Stats and Delete query for them
Query for getting them:
SELECT name, OBJECT_NAME(OBJECT_ID)
FROM sys.stats
WHERE auto_created = 1;
Delete query for one of the table stats:
DROP STATISTICS TableName.StatisticsName
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment