View'larda geçen tablo isimlerini arama

SELECT TABLE_NAME, REPLACE(REPLACE(VIEW_DEFINITION,'2016','2017'),'CREATE VIEW','alter VIEW') AS SCRIPT
FROM   INFORMATION_SCHEMA.VIEWS
WHERE  VIEW_DEFINITION like '%ONTESCIL_2016%'