O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5: Knowing the Major Components of SQL

In This Chapter

arrow The Data Definition Language (DDL)

arrow The Data Maintenance Language (DML)

arrow The Data Control Language (DCL)

You can view SQL as being divided into three distinct parts, each of which has a different function. With one part, the Data Definition Language (DDL), you can create and revise the structure (the metadata) of a database. With the second part, the Data Manipulation Language (DML), you can operate on the data contained in the database. And with the third part, the Data Control Language (DCL), you can maintain a database’s security and reliability.

In this chapter, I look at each of these SQL components in turn.

Creating a Database with the Data Definition Language

The Data Definition Language (DDL) is the part of SQL that you use to create a database and all of its structural components, including tables, views, schemas, and other objects. It is also the tool that you use to modify the structure of an existing database or destroy it after you no longer need it.

In the text that follows, I tell you about the structure of a relational database. Then I give you instructions for creating your own SQL database with some ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required