The following example creates a library database with a 10MB primary data
file and a 3 MB log file:

CREATE DATABASE library
ON
  PRIMARY ( NAME=library_data,
  FILENAME='c:\mssql7\data\library.mdf',
  SIZE=10MB,
  MAXSIZE=15MB,
  FILEGROWTH=1MB)
LOG ON
  ( NAME=library_log,
  FILENAME='c:\mssql7\data\library.Ldf',
  SIZE=3MB,
  MAXSIZE=5MB,
  FILEGROWTH=1MB)


The following example drops multiple databases with one statement
DROP DATABASE library, northwind, pubs