Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 sys.stats_columns (Transact-SQL)
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
sys.stats_columns (Transact-SQL)

Contains a row for each column that is part of sys.stats statistics.

Column name

Data type

Description

object_id

int

ID of the object of which this column is part.

stats_id

int

ID of the statistics of which this column is part.

stats_column_id

int

1-based ordinal within set of stats columns.

column_id

int

ID of the column from sys.columns.

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2012 Microsoft. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker