GuillermoParedes
10/9/2018 - 1:18 PM

SQL

Encontrar un nombre de campo, en toda la base de datos.

findColumn
content_copyfile_download
SELECT TABLE_NAME,*
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%NombreDeCampo%'
searchRowInDB
content_copyfile_download

SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%class_id%'