Querying the Database

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

Home >  Tutorials > "ZooDB" Database >

Querying the Database

From time to time, you will want to query your database to see which data is stored in the individual tables. DatabaseSpy provides several possibilities for doing this.

 

Objective

In this section of the tutorial, you will learn how to query the database. Specifically, you will learn how to do the following:

 

Query the zoo database using multiple queries in a script
Create queries using drag and drop

 

Commands used in this section

Icon

Command name

Description

ic_execute-sql

Execute

This command is located in the toolbar of an SQL Editor window and in the SQL Editor menu. Click this command to execute the SQL in the SQL Editor window.

ic_insert-target-single

Define Target Name

This command is located in the SQL Script toolbar and in the SQL Editor menu. Clicking this command will insert a comment defining a name for the Result tab before the statement in which the cursor is currently located.

ic_select-entire-stmt

Current statement

This command is located in the toolbar of an SQL Editor window. Click this command to select the statement in which the cursor is currently located.


© 2019 Altova GmbH