I'd like identify all views and procedures in a HANA DB that use a given table. In SQL Server, one can query
FROM sysobjects o
JOIN syscomments c
ON o.id = c.id
WHERE c.comment LIKE '%tableName%'
Well that didn't take long to find. An answer can be found on the SCN.
SELECT Procedure_Name FROM sys.procedures WHERE Definition LIKE '%tableName%'