Skip to main content

SLAM_metadata_objects

Retrieves Salesforce object definitions to table METADATA_OBJECTS.

warning

The list of objects returned is subject to Salesforce permissions.

Parameters:

NameTypeDefaultDescription
@exists_actionVARCHAR(20)NULLAction to take if the METADATA_OBJECTS table already exists. If NULL, uses the value from SLAM_Settings.default_exists_action (defaulted to 'drop' during initial setup).

Valid options:
  • 'drop'
  • 'rename'
  • 'fail'

Usage Examples:

EXEC dbo.SLAM_metadata_objects

SELECT * FROM METADATA_OBJECTS

With explicit exists action:

EXEC dbo.SLAM_metadata_objects
@exists_action = 'rename'