9 lines
195 B
MySQL
9 lines
195 B
MySQL
|
CREATE PROCEDURE RemoveUser @UserID integer
|
||
|
|
AS
|
||
|
|
DELETE FROM RoleAllocation
|
||
|
|
WHERE UserID = @UserID;
|
||
|
|
DELETE FROM ProfilePicture
|
||
|
|
WHERE UserID = @UserID;
|
||
|
|
DELETE FROM Comment
|
||
|
|
WHERE UserID = @UserID;
|
||
|
|
GO
|