Code completion in queries

PI SQL Commander Lite includes a code-completion aid that can reduce the number of keystrokes to complete a query and increase your understanding of the available options.

Code completion works on various SQL keywords. For example, if you type WHERE, a space, and then type a letter, a list of valid options appears. The completion list includes columns, tables, Table-Valued Functions (TVFs), views, schemas, and catalogs that are valid in that location in the query. You can do any of the following:

• Press Page Up, Page Down, or the arrow keys to select an option from the list.

• Press Tab or Enter to insert the selected option into the query.

• Use your mouse to select an option from the list.

• Continue typing to further filter the list.

• Type the first letter of each word in a camel-cased option to see those matches. For example, type eft to find EventFrameTemplate.

• Continue typing normally and the list will close when you press the spacebar.

An icon to the left of each option indicates the type and can aid in selecting the correct option.

Code completion for nested queries is not supported. For example, if you have the following query:

SELECT *
FROM
(
SELECT TOP 10 Element, Path
FROM Master.Element.Attribute
)t
WHERE t.

When you type t., which is the alias for the nested query, no code completion options are given.