All Products
Search
Document Center

Generate SQL templates

Last Updated: Jun 08, 2019

This topic describes how to generate SQL templates in DMS.

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 left-side table list, right-click the table you want to copy and select Generate Template SQL.

    The Generate Template SQL entrance

  3. DMS generates SQL statement templates for the selected table, including the INSERT, UPDATE, SELECT, and CREATE TABLE templates. You can use these templates when performing SQL operations.