快速查詢到資料表的索引設定

想要快速查詢到資料表的索引設定,可以用什麼指令?

sp_helpindex iech43h

iech43h_1      clustered, unique located on PRIMARY    ch_ym, ch_ym1, el_no, su_no, od_id, ch_rate
iech43h_2      nonclustered located on PRIMARY          ch_ym, ch_ym1, el_no
iech43h_3      nonclustered located on PRIMARY          ch_yy
pk_iech43h    nonclustered, unique, primary key located on PRIMARY    uid

沒有留言: