想要快速查詢到資料表的索引設定,可以用什麼指令?
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
沒有留言:
張貼留言