"DeleteRole" Stored Procedure

Description:

This stored procedure deletes the selected role from the database. The input parameter is RoleID, the primary key for the record.

Definition:
    
    CREATE PROCEDURE DeleteRole
    (
        @RoleID int
    )
    AS

    DELETE FROM
        Roles

    WHERE
        RoleID = @RoleID
        
Database Tables Used:

Roles:  Each record in the Roles table defines a unique role in the selected portal. Users are added to a role via the UserRoles lookup value table.

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