Database Management Thing Shape Services
The following services are among those found on the database management Thing Shape (PTC.SCA.SCO.DBManagementThingShape):
Cascade Delete Services
BatchCascadeDelete—Executes a cascade delete for all specified entities. Calls the CollectActionForCascadeDelete service to gather the list of actions, then performs it.
• Input parameters:
◦ infoTable (INFOTABLE)
◦ deleteReference (BOOLEAN)
• Output: infoTable (INFOTABLE—PTC.SCA.SCO.BatchAction Data Shape)
CascadeDelete—Deletes the specified entity, and all referencing and referenced entities, based on the onDelete and deleteReference settings for each foreign key.
• Input parameters:
◦ dataShapeName (DATASHAPE)
◦ UID (STRING)
◦ deleteReference (BOOLEAN)
• Output: infoTable (INFOTABLE—PTC.SCA.SCO.BatchAction Data Shape)
CollectActionForCascadeDelete—Gathers all of the actions to be performed when deleting the specified entities, based on the
onDelete and
deleteReference settings for each foreign key. Returns the list of actions to be performed. This service can be executed on its own to see what would happen if specified entities were deleted. For more information, see
Setting the Delete Behavior with Foreign Keys.
• Input parameters:
◦ infoTable (INFOTABLE)
◦ deleteReference (BOOLEAN)
• Output: infoTable (INFOTABLE—PTC.SCA.SCO.BatchAction Data Shape)