consultar campos en base de datos

SELECT
    TABLE_NAME,COLUMN_NAME
FROM
    INFORMATION_SCHEMA.COLUMNS
WHERE
    TABLE_SCHEMA = "guiagps2devdb"
and
    column_name like 'id_valor';