The command drop login removes an Adaptive Server user login by deleting the user’s entry from master.dbo.syslogins.
You cannot drop a login who is a user in any database, and you cannot drop a user from a database if the user owns any objects in that database or has granted any permissions on objects to other users. The dropped login account's server user ID ( suid ) can be reused when the next login account is created. This only occurs when the dropped login holds the highest suid in syslogins , but could compromise accountability if execution of drop login is not being audited. You cannot drop the last remaining System Security Officer's or System Administrator's login account.
The with override clause drops the login even if there are non-available databases that cannot be checked for login references.
The following example drops login accounts mikeb and rchin.
drop login mikeb, rchin
See the Reference Manual: Commands for complete drop login syntax.
