Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select OBJECT_SCHEMA_NAME(S.object_id) + N'.' + OBJECT_NAME(S.object_id) TableName,
- S.name StatsName,
- S.stats_id,
- SP.*
- From sys.stats S
- Cross Apply sys.dm_db_stats_properties(S.object_id, S.stats_id) SP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement