_ DDL and DML, the basics_

I keep seeing these two terms thrown around whenever people talk SQL, so here's what I've picked up about them so far.

DDL stands for Data Definition Language. Basically, these are the commands that deal with the structure of a database — the tables themselves, not what's sitting inside them. If you're creating a table, changing its columns, or getting rid of it completely, that's DDL.

Say I'm building a small table to track books at a library:

sql