9. DATA DEFINITION LANGUAGE (DDL)

9.2.1: DDL Commands

We will illustrate three DDL commands (create table, alter table, create index) as we create the library database.

 

image
                       Figure 9.3: Data Definition Commands

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.

License

Share This Book