DIR Return Create A Forum - Home
---------------------------------------------------------
ExcelSoft Database Professionals
HTML 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
*****************************************************