In the IDE

When you run the SQL script, the output displays in the Script Output page of the SQL Worksheet:

Script Output on SQL Worksheet

The Database Navigator lets you view and edit database objects directly in your database. Database connections that are owned by the IDE (available to all applications) are displayed under an IDE Connections node. If a connection is owned by an application, it is displayed under a node for the owning application, for example CreateDBObjects. The DBDEMO connection under CreateDBObjects contains the database objects you have just generated.

Database Navigator

In the Application Navigator, Application Resources panel, if you expand Database | DBDEMO under Connections, you should also see the database objects you have generated.