How to retrieve table column metadata?


I’d like to retrieve types of columns in a table and their metadata, e.g. type, select options and colours.
Is there an API for this?


There’s no metadata available at all. :frowning:


@Chester_McLaughlin 's solution here is the best you will do:

I read his post, thought, wow, that seems like a terrible hack, but tried it, and got remarkably useful information out of it. An API, it is not.

I’d love to see a metadata API tho, it would make writing generic tools which interact with existing bases a whole lot easier.