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.
Definition:CREATE PROCEDURE DeleteModule ( @ModuleID int ) AS DELETE FROM Modules WHERE ModuleID = @ModuleIDDatabase Tables Used:
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.