Adding Tables to the Database
In the previous section, you have created a database project and added a connection to a database. However, this database does not contain any tables yet. In this section of the tutorial, you will learn how to use SQL scripts and the Design Editor to create the tables that make up the "ZooDB" database. Specifically, you will learn how to do the following:
•Open and execute an SQL file
•Add a table using the Design Editor
•Generate and modify a CREATE statement
•Add a new column to a table