This discussion is archived
0 Replies Latest reply: Dec 5, 2012 9:57 AM by user206823 RSS

designer report

user206823 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points