sys.xml_indexes

Description

Returns one row per XML index. Nonnull = Secondary XML index. Nonnull is a self-join reference to the primary XML index. Type description of secondary index: R = PROPERTY secondary XML index Type description of secondary index: PATH = PATH secondary XML index VALUE = VALUE secondary XML index PROPERTY = PROPERTY secondary xml indexes.