"DeleteModule" Stored Procedure

This stored procedure deletes the selected module instance from a portal tab, and from the database. The input parameter is ModuleID, the primary key for the record.

    
    CREATE PROCEDURE DeleteModule
    (
        @ModuleID       int
    )
    AS

    DELETE FROM 
        Modules 
    WHERE 
        ModuleID = @ModuleID
        

Modules:  Each record in the Modules table represents a single module instance on a specific tab in the selected portal. The definition for the module type is pulled via the ModuleDefID field from the ModuleDefinitions table. The data for the module is stored in a database table for the selected module type, and indexed by ModuleID.

The primary key in this table is the ModuleID identity field.