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...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Thu, Jan 3 2008
Filed under: Filed under: sql server, indexes, databases, sql queen, script, columns, kalen delaney, sp_help, included, sp_helpindex