In the following article we would rename a Sybase ASE DB named ABC to DEF. In order to rename the database we need to set the database in single user mode, by using the following command:-

sp_dboption 'ABC','single user',true
go
use ABC
go
checkpoint
go

Once the DB is set to single user mode, we would call the sp_renamedb procedure by using following command:-

sp_renamedb 'ABC','DEF'

go 

Then as a last step we would take the database out of single user mode:-

sp_dboption 'DEF','single user',false

go

use DEF

go

checkpoint

go