labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_DeleteUser
Parameters
Name
Type
Mode
UID
int(11)
IN
UName
varchar(50)
IN
Definition
BEGIN DELETE FROM users WHERE UserID=UID; DELETE FROM mysql.db WHERE db.User=UName; DELETE FROM mysql.tables_priv WHERE tables_priv.User=UName; DELETE FROM mysql.user WHERE user.User=UName; END