List Issue Type Schemes

[Deleted user]

What is the SQL query/table to get the list of IssueTypeSchemes??  Not IssueTypeSCREENSchemes, but just the IssueTypeSchemes?

JIRA v5.0.4

I can't locate a table.  I can't seem to find any (useful, relevant, coherent) info regarding this on the interwebs or here.

Much appreciated!

[Deleted user]

Happened upon my answer looking for something else (not obvious or anything eh?)

select * from fieldconfigscheme where fieldid='issuetype';

[Steven F Behnke]

Thanks for posting the answer. I would agree that is not too obvious.