Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tkizer
Almighty SQL Goddess
38200 Posts |
 Posted - 2002-11-06 : 19:31:16
|
| I am working on a script that will write out the DBCC SHOW_STATISTICS command for every table and each of its indexes. In order to finish up this script, I need to weed out the rows that I don't want. Does anyone know which column in the sysindexes table identifies whether or not it is a statistic? I can't find the answer in BOL. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-11-07 : 04:05:48
|
| You can use INDEXPROPERTY and the 'IsStatistics' property. Have a look at INDEXPROPERTY in BOLHTHJasper Smith |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-07 : 12:48:51
|
| Thank You! This is exactly what I needed. |
|
|
|
|
|
|
sysindexes table