Is adding the ‘tbl’ prefix to table names really a problem?
108
votes
18
answers
45473
views
I’m watching some Brent Ozar videos (like this one, for instance ) and he suggests not prefixing tables with
‘tbl’
or ‘TBL’
.
On the internet I found some blogs saying it adds nothing to documentation, and also that “it takes longer to read it”.
**Questions and considerations**
- **It this really a problem?** Because I’m prefixing tables with ‘tbl’ since my first dba job (the senior DBA told me to do that for organization).
- **Is this something that I need to get rid of?** I made some tests, copying a really big table and giving it the ‘tbl’ prefix, while keeping the other one without it, and I didn’t notice any performance issue.
Asked by Racer SQL
(7546 rep)
Nov 4, 2016, 12:13 PM
Last activity: Mar 21, 2022, 03:30 PM
Last activity: Mar 21, 2022, 03:30 PM