搜索了半天总算搞到了
其实好像很简单的样子

select name
from syscolumns a
where exists (
select *
from sysindexkeys b
where b.id=object_id(N'表名') and a.id=b.id and a.colid=b.colid)