Using Auto-Completion

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

Home >  Tutorials > "ZooDB" Database >

Using Auto-Completion

In DatabaseSpy, the auto-completion feature assists you when entering SQL statements in the SQL Editor. As you type, you are offered different possible SQL keywords or names of database objects to choose from.

 

The SQL syntax depends on the specific SQL flavor you are using. This is automatically determined by the connection string you defined using the Connection wizard, i.e., the Create a Database Connection option.

 

Objective

In this section of the tutorial you will learn how to use the auto-completion feature in DatabaseSpy. Specifically, you will add a new column to the table tblVeterinarians while using auto-completion.

 

Command used in this section

Icon

Command name

Description

ic_new-sql-editor

SQL Editor

This command is located in the Standard toolbar; alternatively, you can also choose the menu option File | New | SQL Editor or press Ctrl+N. Click this command to open a new SQL Editor window that is assigned to the active data source connection.

ic_refresh-datasource

Refresh

This command is available in the Online Browser as a button, or as an option in the context menu that opens when you right-click a database. Use this command to refresh the database and display new or changed database objects in the Online Browser.

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.


© 2019 Altova GmbH