DB/Assist helps you build SQL Data Manipulation Language (DML) statements (SELECT, UPDATE, DELETE, and INSERT) by allowing you to complete the statement construction dialog boxes, as described in Completing the Statement Construction Dialog Boxes.

You can also build a DML statement by importing it from the clipboard or from a file, as described in Importing a Statement into DB/Assist, or by typing it directly in the SQL Editor window, as described in Typing a Statement in the SQL Editor Window.

However, to build SQL Data Definition Language (DDL) statements, such as CREATE TABLE and DROP, or Data Control Language (DCL) statements, such as GRANT and REVOKE, you must either import the statement or type it in the SQL Editor window. For this release of DB/Assist, you cannot build DDL or DCL statements visually by completing the dialog boxes.