Sybase ASE – Rename a Database

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


One thought on “Sybase ASE – Rename a Database

  1. Pingback: Sybase ASE | Oracle Database Internal Mechanism

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.