I would like to create a report using either the CI tables or SDD. I would like to see the application name, database name, table name and column name. I was able to find a relationship of table to column by joining ci_relation_definitions to ci_columns. Is there a way to then join the application with the database then join the table and columns ..
Thanks, .. I have tried that and have found no link from ci_databases to ci_applicationci_tables to ci_columns ...could have missed it because those diagrams are diffulcult to follow ..
If anyone has any SQL on how to join these, let me know ..