You can use the Database Explorer toolbar to create an SQL statement
in the SQL editor.
The SQL editor supports any statement that can be run by the database
to which you are connected. If you save the SQL statement, it is stored in
a file with the extension .sql.
Prerequisites: If you want to
save the SQL statement, create the project in which to store the statement.
Restriction: - If you want to reopen the SQL statement in the SQL editor or the SQL builder,
save the statement in a data project. The data project
can be a data development project or a data design project.
- If you save the SQL statement in a data development project, the project
must be associated with a database that contains the database tables that
you use in the statement. Otherwise, you cannot run the statement successfully.