User of DTM SQL editor can take advantage of automating the creation of the most used SQL-statements such as:

• SELECT
• UPDATE
• INSERT
• DELETE
• DROP TABLE
• DROP VIEW
• DROP INDEX
• DROP PROCEDURE
• CREATE TABLE
• CREATE INDEX
• CREATE VIEW

First, the user should select the data source connection he or she wants to build the query for using "Schema tree".

The SQL statement created can be saved using one of the following methods:

• Insert - insert the result at the current cursor position
• Append - append the result to the end of the script currently being edited
• Replace - replace the current script

See also:Statements