That guy has a full blown CREATE INDEX command and I will need to parse it to get the info I need.
Follow the foreign keys.
All useful info does get parsed out into columns somewhere. The system doesn't parse a create index command everytime it needs to inspect the properties of the index.