The Data Definition Language (DDL) is used to create and destroy databases and database objects. These commands will primarily be used by database administrators during the setup and removal phases of a database project.
Please respond to all of the following prompts:
- Discuss commands that are used to modify database tables (i.e., CREATE, INSERT, DROP).
- When would you want to use each of these commands?
- Compare and contrast the advantages of tables and views.
- Compare and contrast that advantages of tables and views.