Viewing a Database
The information regarding database such as owner, size, date of creation, and status can be viewed using the following:
The name of database can be changed. The database should not be in use when it is being renamed, and it should be set to the single-user mode.
where, old_name is the original name of the database
new_name is the original name of the database
Only system administrator can changed the name of a database.
Deleting a Database
A database is deleted when it is no longer required. Only the system administrator and database owner have permission to delete a database.
DROP DATABASE database_name
where, database_name is the name of the database