If a database is no longer required on an Adaptive Server, it can be dropped from the server using the drop database command. Databases can be dropped under the following conditions:
- No users are currently connected to the database.
- The databases are not referenced by other databases.
- The drop command is issued from the master database.
- The command is issued by the dbo or SA.
- Only the database owner can execute drop database, except for the sybsecurity database, which can be dropped only by the system security officer
Syntax Sybase Drop Database:
drop database database_name [, database_name]
Example:
We are going to drop database named ‘test’
use master go drop database test go