#81 Modify Column Names

open
nobody
None
5
2012-09-04
2012-09-04
Conrad Stegner
No

I am attempting to analyze the schema used by a software package. The developers decided to put a prefix on the column names that identifies the table. For example, column CMCLMDT is in the CLMMST table, and CDCLMDT is in the CLMDTL table. Because the names are different, SchemaSpy doesn't see any implied relationship. I would like to have an exit in which I can modify each column name as it is retrieved so that the implied relationship can be detected.
Most of the prefixes are two characters, but in some tables it is more, and in a few tables there is no prefix.

Discussion