SQL Statement Builder

The SQL builder is a built-in tool of DTM SQL editor. It is the step-by-step constructor that helps users to create SQL statements. It is suitable for: SELECT, INSERT, UPDATE, DELETE statements. Also, it supports CREATE and DROP for most popular objects: TABLE, VIEW, PROCEDURE, TRIGGER, and INDEX. Limited support for GRANT and REVOKE statements is also available.

How the builder can save your time?

• You should not enter keywords manually - just select required clause.
• You have not to remember exact object (like table or column name), the tool allows you to select it from the list.
• You should not remember exact statement syntax - the builder constructs it from clauses automatically.
• It adds schema (or owner) prefix to table or view automatically.
• You have not to quote values manually. The builder do that automatically depends on column's data type.
• It supports three modes: append, replace and insert - you are allowed to combine results of a few builder executions.

The SQL builder is also suitable for new SQL users. The tool shows currently created statement after each step: it is good visual learning tool for novices.

See Also

• How to use SQL Library for most frequently used statements and queries.
• Does the software suitable for PostgreSQL users and programmers?
• Screenshots.