What is the purpose of sys.index_columns catalog view ?

 Posted by Niladri.Biswas on 4/26/2013 | Category: Sql Server Interview questions | Views: 1185 | Points: 40

The sys.index_columns catalog view provides a list of all of the columns included in an index. For each key and included column that is a part of an index, there is one row in this catalog view. For each of the columns in the index, the order of columns is included along with the order in which the column is sorted in the index.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response