Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Creating Tables and Manipulating Data with SQL Creating a Database

Posted by Judd Higgins
Judd Higgins
8,846 Points

CREATE SCHEMA 'movie_db'; Challenge Task 1 of 2 fail.

I am typing the SQL statement that is being asked for this Challenge to create the database, but I keep getting the error that my statement is wrong. What gives?

1 Answer

David Kaneshiro Jr.
David Kaneshiro Jr.
29,247 Points
David Kaneshiro Jr.
David Kaneshiro Jr.
29,247 Points

I think they want you to use the CREATE DATABASE command instead of CREATE SCHEMA. You also don't need the single quotation marks surrounding movie_db.

Judd Higgins
Judd Higgins
8,846 Points

Yes, that was my problem - adding the single quotes. Thanks much!