SQL DROP USER

The following command will drop a user named Alex.
PostgreSQL, MySQL, Oracle
SQL Server
DROP USER Alex;

SQL Server

Microsoft’s documentation on the difference between login and user.