Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA views or sys.index_columns. Kalen Delaney aka 'SQL Queen' has blogged a wonderful script to get more information for 'included columns' : The issue is SQL Server 2005 "Included Columns". There was a post on the public newsgroups about...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2008/01/03/3102.aspx