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
Select a database, and click Log on to Database.
In the left-side table list, right-click the table you want to copy and select Generate Template SQL.
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.