SQL statements that must be made (i) Create a database and delete a database _mssql

1. Create a database

Create database name on
primary
{Name
  = ' name ',
  filename = ' c:\xx\ name. mdf ',
  size = 10MB,         --Initial size of database
  filegrowth =1MB-     -If the initial size is not enough, 1mb per increment.
  maxsize = 20MB      --The space limit of the database, fill unlimited for unlimited
}
Log on
{
  name= ' name _log ',
  filename = "c:\xx\ name _log.ldf"
  size = 5MB,
  filegrowth = 10%,    There are two ways to grow, one is to grow according to fixed size, one is to increase by percentage!
  maxsize = 10mb
}

2. Delete Database

can only use drop
Drop database name