Adding SQL Files

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Tutorials > "ZooDB" Database > Setting Up a Database Project >

Adding SQL Files

A database project in DatabaseSpy allows you to store SQL files together with the database connection in one project file so that you have all the files and connections you need at hand when you open a project in DatabaseSpy.

 

In this step, you will add the SQL scripts to the project that you will later use to create the tables for the zoo database and to query the zoo database.

 

 

To add the SQL files to the project file:

1.In the Project window, right-click the SQL folder and select Add Files to Project... from the context menu. The Open dialog appears.
2.Select the files to be added to the SQL folder from the tutorial directory:

 

animalType_queries.sql
create_ZooDB_relationships.sql
create_ZooDB_tables.sql
tblAnimalTypes_data.sql

 

3.Click the Open button. The SQL files appear in the SQL folder of the Project window.

tab_project-sql-zooDB


© 2019 Altova GmbH