Check for unused procedures

Introduction

Checks for any procedures in the RED metadata that are not used by any object.

How does it work?

This test case builds a list of all procedure keys used by any object within the RED respository by selecting the respective foreign-keys from the object-definitions.

It then joins this list to a list of keys of all procedures present in the [ws_pro_header] table. If there is one left in the [ws_pro_header] table, that cannot be joined to the first list, it is an unused procedure.

Configuration

No configuration needed

Table of Contents