Paddling Upstream: How to find all HANA views that use a particular table/column

Requirement:

Find all HANA views that use a particular table/column.

If a field is dropped/modified from a table, identify the upstream model impacts.

Problem Faced:

Our team’s analytics was based on tables from multiple source systems.

There were instances where fields were being dropped from source tables as a part of continuous changes.

HOW TO GENERATE ROW NUMBER OR SEQUENCE NUMBER USING HANA GRAPHICAL CALC VIEW RANK

Created a Table name Country in SAP HANA and have following columns:
COUNTRY_NAME        VARCHAR (50)
COUNTRY_ID                INTEGER