All Products
Search
Document Center

Search SQL commands

Last Updated: Jun 07, 2019

This topic describes how to use the SQL command template.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Procedure

  1. Select a database, and click Log on to Database.

  2. In the top navigation bar, choose SQL Operations>SQL Window.

  3. In the SQL window, locate the SQL Template in the right side of the SQL Window, as shown in the following figure.

    SQL template panel

    Notes

    • Callout number 1: SQL command search box. You can search for common SQL commands.
    • Callout number 2: Search results of the SQL commands.
  4. Double-click a command or drag and drop the command into the SQL window to use or view the SQL command, as shown in the following figure.

    Use commands on the SQL template

    Note

    You can modify the content in the template to develop your own SQL statements if you are unfamiliar with the command.