I recently asked a colleague why they had included _TABLE at the end of all their database table names. They said it had been a standard at another orgainisation they had worked for. Other colleagues use V_ at the start of views.
Is this good practice?
Advertisement
Answer
Consistency is the best approach. Adding a _TABLE or _VIEW at the end of an object name is overkill in my book, but if the database is designed that way, I wouldn’t break from convention.
For your colleague to bring his naming convention from a previous organization into a new one without checking ‘local’ standards is bad practice.