Database Management Thing Shape Services
The following services are among those found on the database management Thing Shape (PTC.DBConnection.DBManagement_TS):
Cascade Delete Services
* 
The deleteReference input parameter on a cascade delete service determines whether the service follows the deleteReference settings on foreign keys in the database information for the entity that is being deleted. When the deleteReference input parameter is set to true, all entities referenced by foreign keys which have a deleteReference setting of true are deleted. When the deleteReference input parameter is set to false, the referenced entities are not deleted.
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 (INFOTABLEPTC.DBConnection.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 (INFOTABLEPTC.DBConnection.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 (INFOTABLEPTC.DBConnection.BatchAction Data Shape)
Was this helpful?