Altova DatabaseSpy 2023 Enterprise Edition

Adding Tables to the Database

Home Prev Top Next

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

© 2016-2022 Altova GmbH