Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Enterprise Edition

When entering an SQL statement in the SQL Editor, auto-completion helps you by offering lists of appropriate keywords, data types, identifiers, separators, and operators depending on the type of statement you are entering. By default, auto-completion is invoked automatically in certain contexts (for example, when you start typing a statement).

dbs_autocompletion

Auto-completion

Use the Up and Down keyboard keys to navigate through the list of suggestions. To pick a suggested entry, click it or press Enter.

To disable auto-completion suggestions:

1.On the Tools menu, click Options (or press Ctrl+Alt+O).

2.Click SQL Editor.

3.Under Entry Helpers, clear the Automatically open check box.

To invoke auto-completion suggestions manually as and when required:

In the SQL Editor, press Ctrl+Space.

 

For example, in the image below, auto-completion has been invoked manually by pressing Ctrl+Space. The goal here is to quickly select a table available in the [dbo] schema of a SQL Server database.

dbs_autocompletion_manual

Auto-completion invoked manually

The object types that may appear in the auto-completion window can be identified by icon type, as follows:

 

ic_schemas

Schemas

ic_tables

Tables

ic_views

Views

ic_columns

Columns

ic_functions

Functions

ic_data-type

Data types

ic_procedures

Procedures

ic_keywords

Keywords

ic_separators

Separators

© 2020 Altova GmbH