View Full Version: Lbi Tables/data Dictionary

LawsonTalk > Reporting (NEW!!) > Lbi Tables/data Dictionary



Title: Lbi Tables/data Dictionary
Description: Table/field description relationship


moesplace - May 5, 2008 04:21 PM (GMT)
Does anyone know if there exists a data dictionary for the 3 schemas that make up LBI?
We are particularly interested in the Reporting Services schema, but the other two would be helpful as well.

Something similar to what Lawson's dbdoc output looks like would be awesome!!!

Any help would be appreciated,
-Greg Moeller

cjmart - May 5, 2008 04:54 PM (GMT)
Lawson doesn't publish this type of info to my knowledge. One thing you can do is use a tool like schemaspy, available here:

http://schemaspy.sourceforge.net/

"SchemaSpy is a Java-based tool (requires Java 1.4 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints."

Best of all, it's free...




Hosted for free by InvisionFree