No se si es mejor, pero es mas simple
Publicado por Jose Luis Astudillo Guerra (1 intervención) el 24/02/2010 14:27:25
CREATE PROC SP_BuscarCampoEnTablas( @Campo nvarchar(100) ) AS
BEGIN
SELECT COLUMN_NAME as Campo, TABLE_NAME as Tabla
FROM INFORMATION_SCHEMA.columns
WHERE TABLE_NAME IN(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.tables WHERE TABLE_TYPE='BASE TABLE')
AND COLUMN_NAME Like '%'+ @Campo +'%'
END
BEGIN
SELECT COLUMN_NAME as Campo, TABLE_NAME as Tabla
FROM INFORMATION_SCHEMA.columns
WHERE TABLE_NAME IN(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.tables WHERE TABLE_TYPE='BASE TABLE')
AND COLUMN_NAME Like '%'+ @Campo +'%'
END
Valora esta pregunta
0