Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have run an analysis with SchemaSpy.

The tool gave me a warning message for two tables. The warning message is:

Tables with incrementing column names, potentially indicating denormalization

What is meaning of the above error?

For reference :

share|improve this question
up vote 7 down vote accepted

Based on the sample table in your link, I'd suggest it's taking issue with fields such as:




This may indicate a design flaw (but not always), and if so, one that can probably be corrected by more descriptive field names or perhaps a child table.

For example, someone might have more than one phone number... what if someone has three? Seven? Maybe data like this should be in a subtable, and perhaps even with some sort of indicator of what type of phone number it is, whether it's a preferred phone number, etc. Alternatively, maybe just renaming the fields to phone_home and phone_cell will be enough to eliminate confusion and allow you to collect all of the data you need.

share|improve this answer
Specifically looks as though it takes that as an indicator the table may not be in first normal form then. – Martin Smith May 7 '13 at 12:26
I often see this sort of thing with tables that have fields such for address lines: addressLine1, addressLine2, addressLine3. – FrustratedWithFormsDesigner May 7 '13 at 13:33
It works.. Thanks... Wonder.. How decision making engine considering micro things which we even didn't care... – Shashi May 8 '13 at 5:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.