(DIR) Return Create A Forum - Home --------------------------------------------------------- ExcelSoft Database Professionals (HTM) https://esdbp.createaforum.com --------------------------------------------------------- ***************************************************** (DIR) Return to: Scripts ***************************************************** #Post#: 12-------------------------------------------------- Index Information including included,filtered,column indexes By: srinivasma_exceldbp Date: February 27, 2014, 12:56 am --------------------------------------------------------- sp_helpindex from Microsoft provides only key columns Attached script provides iIndex Information including included,filtered,column indexes There are 3 different versions 1. sql 2005 : sp_lib_helpindex2005 2. sql 2008 : sp_lib_helpindex2008 3. sql 2012 : sp_lib_helpindex2012 sp_lib_ExposeColsInIndexLevels is called by all the above SPs *****************************************************