0 Replies Latest reply: Dec 5, 2012 11:57 AM by joecbc RSS

    designer report

    joecbc
      I would like to create a report that shows

      database name,tablename,column_name,column_length,data_type

      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%'

      Thanks in advance

      Joe G.