ap_check_existence_sp

This procedure accepts a list of object names and return a result set with the names of objects that exist as listed in abasysobjects and their subsystem. This procedure is used by the object-checking feature in AbaPerls.

 

Parameters:

@objects nvarchar(MAX): comma-separated list of objects to look for.

@type varchar(20): what class of objects, if not objects in sys.objects. Not relevant when @objtypes has a value.

@objtypes: nvarchar(MAX): comma-separated list of object types to look for in sys.objects.