• OCTom (4/25/2014)


    The very worst naming convention I saw was years ago on an AS400 (1981).

    Tables are called files on that machine and reside in a library.

    The naming was such:

    Library001

    File001

    Field001

    Field002

    Field003

    File002

    Field001

    Field002

    ...

    Library002

    File001

    ... etc ...

    Their program names were Pgm001, Pgm002, etc.

    It was awful to work with. It was a major ERP system. One of the biggest at the time.

    So, whatever you choose for naming convention, make sure they're clear, consistent, and enforced.

    Tom

    Saves Typing

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.