All Products
Document Center

Search SQL commands

Last Updated: May 11, 2020

This topic describes how to use the SQL command template.


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


  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.


    • 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.

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