9. DATA DEFINITION LANGUAGE (DDL)
We will illustrate three DDL commands (create table, alter table, create index) as we create the library database.
In some database environments we can run more than one command at a time; the commands would be in a file and would be submitted as a batch to be executed. In the following we will demonstrate and run one command at a time.