Show TOC

Getting Support from Content AssistLocate this document in the navigation structure

In the DDL source editor, the content assist proposes valid DDL keywords and identifiers to you that can be inserted within the source code at your current position. Consequently, you can reduce the time spent on code editing and ensure that you are using the valid source code elements.

The following help is provided by the content assist:

  • Keyword completion: The best matching DDL keyword is automatically proposed as soon as you start typing
  • Semantic keyword completion: A list of all matching DDL keywords is displayed for the position where you have chosen the Ctrl + Space shortcut
  • Semantic completion (data source and signature parameter completion): This enables you to insert the best matching data sources (tables) or add the parameters of a table to the DDL source code.
Keyword Completion

In the DDL source code editor, the best matching DDL keyword is displayed when start typing the keyword. If you choose the tabulator key, the keyword is inserted.

Keyword completion in the DDL editor
Figure 1: Keyword completion in the DDL editor
Semantic Keyword Completion

In the DDL source editor, you can open the code completion list manually at any position by choosing Ctrl + Space. This enables you to add the possible keywords to your source code using the Shift + Enter shortcut.

Choose Ctrl + Space to display the list of suggested entries at this position
Figure 2: Choose Ctrl + Space to display the list of suggested entries at this position
Semantic Completion

To get a list of best matching data sources (database tables, database views, CDS views, or CDS table functions), type the first letter(s) of the data source and then press Ctrl + Space.

Data source completion in the DDL editor
Figure 3: Data source completion in the DDL editor

The list with the elements of the signature is automatically displayed after you have typed a dot as the component selector. This enables you to add a component of a table to the DDL source code.

Completion of elements in the DDL editor
Figure 4: Completion of elements in the DDL editor