Skip to main content

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