Sybase Drop login

Sybase Drop login removes login from the Sybase(ASE) server. We cannot Drop Login in following scenarios:

1) If login is added to any user database. We have to drop user from the database using sp_dropuser.
2) We cannot drop logins that own a database or database objects. In this case, we have to change the ownership of database or database objects.
3) We cannot drop login which is currently logged in.

Sybase Drop login Syntax:

drop login login_name [, login_name_list] [ with override ]

Examples for Sybase Drop Login:
1. Drop login named ‘test’.

1> use master
2> go
1> drop login test
2> go

2. Drop login which is added to user databases.

1> drop login karunakar
2> go

The login 'karunakar' is still a user, alias or database owner in 'r2schools' database.
Msg 3770, Level 16, State 1:
Server 'LOCALHOST', Line 1:
The DROP login 'karunakar' failed. See previous messages for more information.

Steps for the above issue:

1. First drop user from the r2schools

use r2schools
go
sp_dropuser karunakar
go

2. Then, run the drop login command.

use master
go
drop login karunakar
go

This removes record from syslogins server system table of master database.