Quick tip for MySQL:
SELECT DISTINCT
TABLE_NAME AS 'tabela',
COLUMN_NAME AS 'coluna'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
COLUMN_NAME LIKE '%parte_do_nome_da_coluna%'
AND
TABLE_SCHEMA='NOME_DO_BANCO';// Bando de Dados · MySQL

Quick tip for MySQL:
SELECT DISTINCT
TABLE_NAME AS 'tabela',
COLUMN_NAME AS 'coluna'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
COLUMN_NAME LIKE '%parte_do_nome_da_coluna%'
AND
TABLE_SCHEMA='NOME_DO_BANCO';
Comments 0
No comments yet.