https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-droprolemember-transact-sql?view=sql-server-ver16
sp_droprolemember (Transact-SQL) - SQL Server | Microsoft Learn
sp_droprolemember removes a security account from a SQL Server role in the current database.
sql serversptransactmicrosoftlearn