# Delete a Role
# Shameema Esufali June 2020

# Change this to your PersonnelID from the Personnel Table. 

SET @roletodelete="Test Role 3";


  
#  Delete a role 

DELETE FROM RoleReference WHERE Description = @roletodelete;  
