close

SELECT

      t.name AS Table_Name,

      i.name AS Index_Name,

      i.type_desc as Index_Type,

      STATS_DATE(i.object_id, i.index_id) AS Date_Updated

FROM

      sys.indexes i JOIN

      sys.tables t ON t.object_id = i.object_id

WHERE

      i.type > 0

      AND i.name LIKE '%missing%'

ORDER BY

      t.name ASC,

      i.type_desc ASC,

      i.name ASC

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 my007FFF 的頭像
    my007FFF

    #007FFF

    my007FFF 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄