I've seen some that some systems adopt a different way of naming tables with letters and numbers like ABC1234, XX_900
, etc.
These days I've been working on creating some queries on a system that uses this type of approach, more than 1200 tabelas
to go through to find out where the data in a given table ( Produtos
) was.
Fortunately, I found some queries that made the task less painful, such as searching all tables for the name of the Produto
column,
SELECT c.name AS 'ColumnName',
t.name AS 'TableName'
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%produto%'
ORDER BY TableName,
ColumnName
Even though the number of tables returned was scary, more than 200!
So the question is:
What is the advantage of using this type of naming for tables? Is it just to hinder the lives of outsiders?