Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Professional Edition

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

© 2019 Altova GmbH