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 = @RoleIDDatabase 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.