Follow SQLMaster on Twitter

How do I find all the statistics and statistics columns on a specified object?

Published 16 July 07 05:46 AM | SQL Master 

USE <database_name>;
GO
SELECT s.name AS statistics_name
    ,c.name AS column_name
    ,sc.stats_column_id
FROM sys.stats AS s
INNER JOIN sys.stats_columns AS sc
    ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id
INNER JOIN sys.columns AS c
    ON sc.object_id = c.object_id AND c.column_id = sc.column_id
WHERE s.object_id = OBJECT_ID('<schema_name.object_name>');
GO

Make sure you have validated the schema_name and database_name before executing this code.

Comments

# SSQA - SqlServer-QA.net said on July 16, 2007 2:16 PM:

USE &lt;database_name&gt;; GO SELECT s.name AS statistics_name ,c.name AS column_name ,sc.stats_column_id

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.

Search

Go

This Blog

«July 2007»
SMTWTFS
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

Syndication