This stored procedure deletes a single contact item from the database. The input parameter is ItemID, the primary key for the record.
Definition:CREATE PROCEDURE DeleteContact ( @ItemID int ) AS DELETE FROM Contacts WHERE ItemID = @ItemIDDatabase Tables Used:
Contacts: Each record in the Contacts table is a single item, as displayed by the Contacts Portal Module. Since all Contacts modules store their record in this table, each item contains a ModuleID to permit related items to be retrieved in a single query.
The primary key in this table is the ItemID identity field.