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