Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

Mayur Pande
Mayur Pande
Courses Plus Student 11,711 Points

Andrew says in this video that DDL modifies the schema.

Why would someone want to do that, is there a reason for it?

1 Answer

Steven Parker
Steven Parker
216,151 Points

The reason to use DDL is that it's how you create and update the organization of your database (the schema).

Say, for example, you have a database that currently stores movie titles. But you decide you also want to keep the year the movie was released. You would use DDL to add the new column for the year to your table schema.

Think of DDL as what you use to change the size and shape of a box, and DML (Data Manipulation Language) as what would change the contents of the box. Both are important tasks in handling your storage needs.