Using Drag and Drop to Create Queries
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 ZooDBConnect data source to connect to it.
2.Click the 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.
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).