SQL Server STORED PROCEDURE:
CREATE PROCEDURE dbo.usp_scorm_DeleteRegistration
(
@scorm_registration_id int
)
AS
SET NOCOUNT ON
DELETE ScormActivityRTComment FROM ScormActivityRTComment a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityRTObjective FROM ScormActivityRTObjective a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityRTIntCorrectResp FROM ScormActivityRTIntCorrectResp a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityRTIntObjective FROM ScormActivityRTIntObjective a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityRTIntLearnerResp FROM ScormActivityRTIntLearnerResp a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityRTInteraction FROM ScormActivityRTInteraction a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityRT FROM ScormActivityRT a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
DELETE ScormActivityObjective FROM ScormActivityObjective a INNER JOIN ScormActivity b ON a.scorm_activity_id = b.scorm_activity_id WHERE
b.scorm_registration_id = @scorm_registration_id
UPDATE ScormRegistration SET suspended_activity_id = NULL WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormActivity WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormLaunchHistory WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormRegistrationGlobalObj WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormRegistrationSSPBucket WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormRegistrationSharedData WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormRegistrationSharedDataVal WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormAiccSession WHERE scorm_registration_id = @scorm_registration_id
DELETE FROM ScormRegistration WHERE scorm_registration_id = @scorm_registration_id
RETURN