Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Professional Edition

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

© 2019 Altova GmbH