Skip to content

Instantly share code, notes, and snippets.

View tsilvonen's full-sized avatar

Tero Silvonen tsilvonen

View GitHub Profile
SELECT
t.Xf$Name AS TableName,
i.Xi$Number AS IndexNumber,
i.Xi$Part AS FieldNumber,
f.Xe$Name AS FieldName
FROM X$File t
INNER JOIN X$Index i ON
i.Xi$File=t.Xf$Id
INNER JOIN X$Field f ON
f.Xe$Id=i.Xi$Field