LV
Back to writing

// Bando de Dados · MySQL

Query to Find a Column Across the Whole Database [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.