摘要： 方法1. 使用系统表-- 查询一个表中的索引及索引列USE AdventureWorks2008GOSELECT indexname = a.name , tablename = c. name , indexcolumns = d .name , a .indidFROM sysindexes a JOIN sysindexkeys b ON a .id = b .id AND a .indid = b.indid JOIN sysobjects c ON b .id = c .id JOIN syscolumns d ON b .id = d .id ... 阅读全文