Adding SQL statements to the DDL scripts that are generated by the workbench is useful if you commonly require SQL statements to run that are not supported by the underlying SQL model. For example, you might want to always include GRANT or REVOKE statements before or after the DDL statements. When you set the statement syntax in the Preferences window, these statements are automatically added to the generated DDL scripts so that you do not need to modify the DDL script manually to add these statements.
SET CURRENT SQLID = {schema}
SELECT, UPDATE, INSERT ON TABLE {table} TO PUBLIC
GRAND DELETE ON TABLE {view} TO {schema}
GRAND DELETE ON TABLE VIEW1 TO RTESCHMA; DROP VIEW VIEW1; DROP TABLE TABLE1; SET CURRENT SQLID = RTESCHMA; CREATE TABLE TABLE2 ( C1 INTEGER, C2 INTEGER ); GRAND SELECT, UPDATE, INSERT ON TABLE TABLE2 TO PUBLIC; CREATE VIEW VIEW1 AS (SELECT C2 FROM RTESCHMA.TABLE2)
To set preferences for DDL generation: