Haven't seen a COL_ prefix in a long time, but I still run across 'TBL_' prefixes sometimes. I've seen it in practice for more than 20 years, and never saw any

Haven't seen a COL_ prefix in a long time, but I still run across 'TBL_' prefixes sometimes. I've seen it in practice for more than 20 years, and never saw any value. Then... I realized you might be pulling from a 'view' vs an actual table, and perhaps there's a bit of value in that knowledge? I did run across someone joining a view against a table that was joining another view that was comprised of joining against that original table, and the query then did a few of these, and people wondered why it got slow. If the names had been prefixed with view_ perhaps it might have been more obvious this might cause problems? I think not though - the original person who put it together was apparently a DBA by trade and insisted this was normal and good, and 'my' code (which... he'd also written?) was the culprit. "Worked fine when I was there". Well... there were 1200 rows at that time; hitting 60000 rows, we ran in to large perf problems.