###################
# Create Database #
###################
CREATE DATABASE Meals
ON
  (NAME = meals_data,
   FILENAME = 'C:\Temp\Meals.mdf',
   SIZE = 2MB,
   MAXSIZE = 10MB,
   FILEGROWTH = 2MB
)
LOG ON
  (NAME = meals_log,
   FILENAME = 'C:\Temp\Meals.ldf',
   SIZE = 1MB,
   MAXSIZE = 5MB,
   FILEGROWTH = 1MB
);

################
# Use Database #
################
USE Meals;

###############
# Make Tables #
###############
# Foods.
CREATE TABLE Foods (
    FoodName VARCHAR(40) UNIQUE NOT NULL
);

###############
# Fill Tables #
###############
INSERT INTO Foods VALUES ('Cookie');
INSERT INTO Foods VALUES ('Beans');
INSERT INTO Foods VALUES ('Bread');
INSERT INTO Foods VALUES ('Apple');
INSERT INTO Foods VALUES ('Pie');
INSERT INTO Foods VALUES ('Lasagne');
INSERT INTO Foods VALUES ('Toast');
INSERT INTO Foods VALUES ('Orange');

###############
# Select Data #
###############
SELECT * FROM Foods ORDER BY FoodName;

###############
# Drop Tables #
###############
DROP TABLE Foods;

#################
# Drop Database #
#################
USE MASTER;
DROP DATABASE Meals;