Thursday, March 22, 2007

Why to prefix Database objects?

Reviewing a database with a lot of tables is no easy task, especially when you didn't make the database. It seems like it would make everyone's life easier is if people would prefix their database objects in a way that helps group DB objects logically.
For example, there are tables in a database specifically used for
Metadata for the application. It would be nice if they were prefixed with "MD_"(Meta data) to denote that they are
Metadata tables. Instead of tables X, Y, and Z intermingled with the rest of the tables in the database, they would be nicely grouped together as MD_X, MD_Y and MD_Z.
But even if everyone were to start prefixing their databases the way I want right now, it wouldn't help me out with the one I've already got.

No comments: