sp_helpstats (Transact-SQL)

[ @objname=] 'object_name'

Specifies the table on which to provide statistics information. object_name is nvarchar(520) and cannot be null. A one- or two-part name can be specified.

[ @results=] 'value'

Specifies the extent of information to provide. Valid entries are ALL and STATS. ALL lists statistics for all indexes and also columns that have statistics created on them; STATS only lists statistics not associated with an index. value is nvarchar(5) with a default of STATS.

0 (success) or 1 (failure)

The following table describes the columns in the result set.

Use DBCC SHOW_STATISTICS to display detailed statistics information about any particular index or statistics. For more information, see DBCC SHOW_STATISTICS (Transact-SQL) and sp_helpindex (Transact-SQL).

Requires membership in the public role.

The following example creates single-column statistics for all eligible columns for all user tables in the AdventureWorks2012 database by executing sp_createstats. Then, sp_helpstats is run to find the resultant statistics created on the Customer table.

USE AdventureWorks2012;
GO
EXEC sp_createstats;
GO
EXEC sp_helpstats 
@objname = 'Sales.Customer',
@results = 'ALL'

Here is the result set.

statistics_name               statistics_keys

----------------------------  ----------------

_WA_Sys_00000003_22AA2996     AccountNumber

AK_Customer_AccountNumber     AccountNumber

AK_Customer_rowguid           rowguid

CustomerType                  CustomerType

IX_Customer_TerritoryID       TerritoryID

ModifiedDate                  ModifiedDate

PK_Customer_CustomerID        CustomerID

Reference