I would like this to be done by joining the designer CI tables. I am having an issue trying to find out what tables to use. I have looked at CI_ATTRIBUTES, CI_CIOLUMNS etc. I cannot figure our what to join on in order to produce a readable report.
All I want is to be able to enter a tablename, or column name and produce a list of the database/table/column/type. I would also like to just put in a partial search, i.e., I would like to find any columns that have the name TOOLS in them .. select from something where column name like '%TOOLS%'