Codice: Seleziona tutto
USE nomedb
GO
SELECT
v.name,
m.definition
FROM
sys.views v
INNER JOIN
sys.sql_modules m ON v.object_ID = m.object_id
WHERE m.definition LIKE '%testo da cercare%'
Codice: Seleziona tutto
USE nomedb
GO
SELECT
v.name,
m.definition
FROM
sys.views v
INNER JOIN
sys.sql_modules m ON v.object_ID = m.object_id
WHERE m.definition LIKE '%testo da cercare%'