摘要: 方法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 ... 阅读全文
posted @ 2013-08-23 17:57 _cc 阅读(35386) 评论(6) 推荐(3) 编辑