You can manage schemas directly using the SQL statement, CREATE SCHEMA. This statement allows you to create a schema, create the tables and views in that schema, and grant appropriate permissions as a unit. For more information on this statement, see the SQL Reference Guide.

Various SQL statements allow you to specify a schema name to indicate a table or view belonging to a schema other than the one associated with the current user, as described in the SQL Reference Guide.

In VDBA, a schema is created for you automatically, and objects that you create are added to your schema. View the contents of your schema using the Schemas branch for a particular database in the Database Object Manager window.