I am getting an error msg 911 Level 16 State 1 Line 12 Datab

I am getting an error:

msg 911, Level 16, State 1, Line 12 Database \'MyWebDB\' does not exist. Make sure that the name is entered correctly.

This is my homework I am needing to implement this into a create table MyWebDB and I have the error, what have I done incorrectly?

--Write a script that implements the following design in a database named MyWebDB: --In the Downloads table, the UserID and ProductID columns are the foreign keys. --Include a statement to drop the database if it already exists. --Include statements to create and select the database. --Include any indexes that you think are necessary.

DROP DATABASE MyWebDB;

CREATE Database MyWebDB;

USE MyWebDB

Create table users (

UserID int,

EmaiAddress varchar(255),

FirstName varchar(255),

LastName varchar(255),

Constraint pk_UserIDPRIMARYKEY (UserID)

);

Create table Products (

ProductsID int,

ProductName varchar(255),

Constraint pk_ProductsIDPRIMARYKEY (ProductsID)

);

Create table Downloads (

DownloadID int,

DownloadDate Date,

FileName varchar(255),

ProductsID int,

UserID int,

Constraint fk_ProDownloadFOREIGNKEY (ProductsID)

References Products (ProductsID),

Constraint fk_UsersDownloadFOREIGNKEY (UserID)

References Users (UserID)

);

Solution

I ran the same queries on my machine it is working fine..

Script which will implement the above design :

MyWebDB::

USE [master]

GO

/****** Object: Database [MyWebDB] Script Date: 22-11-2016 15:41:32 ******/

CREATE DATABASE [MyWebDB]

CONTAINMENT = NONE

ON PRIMARY

( NAME = N\'MyWebDB\', FILENAME = N\'c:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQL2012\\MSSQL\\DATA\\MyWebDB.mdf\' , SIZE = 4160KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

LOG ON

( NAME = N\'MyWebDB_log\', FILENAME = N\'c:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQL2012\\MSSQL\\DATA\\MyWebDB_log.ldf\' , SIZE = 1040KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

GO

ALTER DATABASE [MyWebDB] SET COMPATIBILITY_LEVEL = 110

GO

IF (1 = FULLTEXTSERVICEPROPERTY(\'IsFullTextInstalled\'))

begin

EXEC [MyWebDB].[dbo].[sp_fulltext_database] @action = \'enable\'

end

GO

ALTER DATABASE [MyWebDB] SET ANSI_NULL_DEFAULT OFF

GO

ALTER DATABASE [MyWebDB] SET ANSI_NULLS OFF

GO

ALTER DATABASE [MyWebDB] SET ANSI_PADDING OFF

GO

ALTER DATABASE [MyWebDB] SET ANSI_WARNINGS OFF

GO

ALTER DATABASE [MyWebDB] SET ARITHABORT OFF

GO

ALTER DATABASE [MyWebDB] SET AUTO_CLOSE ON

GO

ALTER DATABASE [MyWebDB] SET AUTO_CREATE_STATISTICS ON

GO

ALTER DATABASE [MyWebDB] SET AUTO_SHRINK OFF

GO

ALTER DATABASE [MyWebDB] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [MyWebDB] SET CURSOR_CLOSE_ON_COMMIT OFF

GO

ALTER DATABASE [MyWebDB] SET CURSOR_DEFAULT GLOBAL

GO

ALTER DATABASE [MyWebDB] SET CONCAT_NULL_YIELDS_NULL OFF

GO

ALTER DATABASE [MyWebDB] SET NUMERIC_ROUNDABORT OFF

GO

ALTER DATABASE [MyWebDB] SET QUOTED_IDENTIFIER OFF

GO

ALTER DATABASE [MyWebDB] SET RECURSIVE_TRIGGERS OFF

GO

ALTER DATABASE [MyWebDB] SET ENABLE_BROKER

GO

ALTER DATABASE [MyWebDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

GO

ALTER DATABASE [MyWebDB] SET DATE_CORRELATION_OPTIMIZATION OFF

GO

ALTER DATABASE [MyWebDB] SET TRUSTWORTHY OFF

GO

ALTER DATABASE [MyWebDB] SET ALLOW_SNAPSHOT_ISOLATION OFF

GO

ALTER DATABASE [MyWebDB] SET PARAMETERIZATION SIMPLE

GO

ALTER DATABASE [MyWebDB] SET READ_COMMITTED_SNAPSHOT OFF

GO

ALTER DATABASE [MyWebDB] SET HONOR_BROKER_PRIORITY OFF

GO

ALTER DATABASE [MyWebDB] SET RECOVERY SIMPLE

GO

ALTER DATABASE [MyWebDB] SET MULTI_USER

GO

ALTER DATABASE [MyWebDB] SET PAGE_VERIFY CHECKSUM

GO

ALTER DATABASE [MyWebDB] SET DB_CHAINING OFF

GO

ALTER DATABASE [MyWebDB] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )

GO

ALTER DATABASE [MyWebDB] SET TARGET_RECOVERY_TIME = 0 SECONDS

GO

ALTER DATABASE [MyWebDB] SET READ_WRITE

GO

Downloads::

USE [MyWebDB]

GO

/****** Object: Table [dbo].[Downloads] Script Date: 22-11-2016 16:12:33 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Downloads](

[DownloadID] [int] NULL,

[DownloadDate] [date] NULL,

[FileName] [varchar](255) NULL,

[ProductsID] [int] NULL,

[UserID] [int] NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[Downloads] WITH CHECK ADD CONSTRAINT [fk_ProDownload] FOREIGN KEY([ProductsID])

REFERENCES [dbo].[Products] ([ProductsID])

GO

ALTER TABLE [dbo].[Downloads] CHECK CONSTRAINT [fk_ProDownload]

GO

ALTER TABLE [dbo].[Downloads] WITH CHECK ADD CONSTRAINT [fk_UsersDownload] FOREIGN KEY([UserID])

REFERENCES [dbo].[users] ([UserID])

GO

ALTER TABLE [dbo].[Downloads] CHECK CONSTRAINT [fk_UsersDownload]

GO

Products:

USE [MyWebDB]

GO

/****** Object: Table [dbo].[Products] Script Date: 22-11-2016 16:13:01 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Products](

[ProductsID] [int] NOT NULL,

[ProductName] [varchar](255) NULL,

CONSTRAINT [pk_ProductsID] PRIMARY KEY CLUSTERED

(

[ProductsID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

Users::

USE [MyWebDB]

GO

/****** Object: Table [dbo].[users] Script Date: 22-11-2016 16:13:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[users](

[UserID] [int] NOT NULL,

[EmaiAddress] [varchar](255) NULL,

[FirstName] [varchar](255) NULL,

[LastName] [varchar](255) NULL,

CONSTRAINT [pk_UserID] PRIMARY KEY CLUSTERED

(

[UserID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO