Creating a user database with create database

You can create a new database if a system administrator has granted you permission to use create database. You must be using the master database when you create a new database. In many enterprises, a system administrator creates all databases. The creator of a database is its owner. Another user who creates a database for you can use sp_changedbowner to transfer ownership of it.

The database owner is responsible for giving users access to the database and for granting and revoking certain other permissions to users. In some organizations, the database owner is also responsible for maintaining regular backups of the database and for reloading it in case of system failure. The database owner can use the setuser command to temporarily attain any other user’s permissions on a database.

Because each database is allocated a significant amount of space, even if it contains only small amounts of data, you may not have permission to use create database.

The simplest form of create database is:

create database database_name

To create a new database called newpubs database, verify you are using the master database rather than pubs2, then enter:

use master
create database newpubs 
drop database newpubs
use pubs2