Altova DatabaseSpy 2024 Enterprise Edition

Using Drag and Drop to Create Queries

Home Prev Top Next

In DatabaseSpy, the easiest way to generate a query is to drag a database object like a table or column from the Online Browser into an SQL Editor window, for example:

 

1.Open the "ZooDB" project created previously and double-click the dbs_ic_connected ZooDBConnect data source to connect to it.

2.Click the SQL Editor ic_new-sql-editor toolbar button or select the menu option File | New | SQL Editor (Ctrl+N). A new SQL Editor window opens.

3.Drag and drop any table (tblZookepers, in this example) from the Online Browser into the SQL Editor.

dbs_zoo_queries_01

By default, this generates a SELECT statement. You can also modify the behavior above so that other statement kinds (like INSERT, CREATE, or UPDATE) are generated by default.

To configure the statement kind generated by default:

1.On the Tools menu, click Options.

2.Click the "Online Browser" page and choose the desired action next to each object (for example, SELECT for tables).

dbs_zoo_queries_02

© 2017-2023 Altova GmbH