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.