How to find / list all views with specific string?
I found the equivalent for the stored procedure:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
WHERE ROUTINE_DEFINITION LIKE '%foo%'
This is exactly what I am looking for but this only shows procedures... I want to have a list of the views...