"DeleteLink" Stored Procedure

Description:

This stored procedure deletes a single link item from the database. The input parameter is ItemID, the primary key for the record.

Definition:
    
    CREATE PROCEDURE DeleteLink
    (
        @ItemID int
    )
    AS

    DELETE FROM
        Links

    WHERE
        ItemID = @ItemID
        
Database Tables Used:

Links:  Each record in the Links table is a hyperlink, as displayed by the Links Portal Module. Since all Links 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. Note that the link description is limited to 4000 characters.