hoping someone has done this before.. otherwise I need to use SAS
SELECT 'show view ' || trim(databasename) || '.' || TABLENAME || ';'
WHERE databasename in ('GRP_CDM_ANALYTIC_ETL',
) AND tablekind = 'V'
ORDER BY TABLENAME;
1 show view GRP_CDM_PROD_DOWNSTREAM.CN_ORT_ADDS;
2 show view GRP_CDM_PROD_DOWNSTREAM.CN_ORT_MDMS;
3 show view GRP_CDM_PROD_DOWNSTREAM.CN_ORT_MIGR;
4 show view GRP_CDM_REPORT_ETL.DLR_RC_EAST;
5 show view GRP_CDM_REPORT_ETL.DLR_RC_NATIONAL;
I now need to look in every show view and search for a specific database such as GRP_CDM_REPORT
Does anyone know how I can?
Execute the show view and then loop through the view code to find a string. When found list which View it was found
Solved! Go to Solution.